I have a table called AccountPeriod which has period_id, startdate,
enddate, description
Another tabled called JournalHeader which contains a foreign key,
period_id - where you select that period to post to

I have - a series of join files for interrelated databases (using FM
5.5).
Here's the situation. One of the fields is an 'average' which averages
all the occurences that meet a certain criteria (specifically, the

I have people entering into a database that includes a large text field
for misc. remarks.   These tend to extend past the size of the field
which causes the field to expand and obstruct the rest of the layout.
I was wondering if there was any good way to solve this problem.

I'm creating a DB and would like to be able to select certain names to
print out.
Example:
We need to create cubical signs from a list that was generated in

I being doing a calculation program but is not working it all.
this is what I want to do:
I have to field "Width" and "lenght" that are regular number fields,
fallow I have 4 check boxes "CC", "DD", "BB" and "Operable"

This is a small error I've encountered occasionally over time.  In a
Text field, I have the following entry:
Army - Navy Screen Magazine #34
With this record active, I enter that text field, do a "Select All"

Please comment on this - what are the good barcode printing solutions,
plug-ins, problems, can this be done without a plug in, are there
international standards for the stripes or the numbering system?
Barcode input is easy, the gun simply acts as an input device, just

After FM8 converts my FM6 file and I attempt to open, FM8 serves -
Open "filename x" using: Account name and Password?  FM8 is getting the
account name from the FM8 application preferences.  But I am at a loss
to what password it is referrring to.  I've tried passwords related to

Is there a simple way to get date from a timestamp field in filemaker
8.5? It seems me really strange there are not inverted function from
timestamp (date; time) to get date and time...

Hi there, I am new to file maker. I have a table called category
(category_id (int) and description (text))
In the Product table, there is a field, category_id which is related to
the category table.

Is there a simple way to get date from a timestamp field in filemaker
8.5? It seems me really strange there are not inverted function from
timestamp (date; time) to get date and time...

I want to put something like "Records 1-11" on the first page, "Records
12-20" on the second page, and so on, of a printed layout that has a
variable number of records per page. Is this possible? Thanks!

In essence this my project :
I have a .log file that I need to convert structuraly to make it
usefull in FileMaker.
- open the logfile

The short version:  Is it possible to restrict the records in a Found
Set based on Layout Name without scripting?
I'm using FMA 8.0v2 on Mac OSX to develop for 7.0-8.5.
The long version:

hi :-)
i have a table of cards where each card is corresponding to one member
(person)
one field is corresponding to the login of the member