Let's say I have a Customer table and a Locations table in a
one-to-many relationship (each customer can have many locations). One
of those locations is checked as the primary address.
I want to display just the primary address on a layout. How do I do

How can I succeed to get an aggregation of data,
look at the following example, where the data
are aggregated by the field with values A,B,C
reducing the new table to sums of A,B and C.

I know how to specify that an ordinary text field is unique in FM7, but I
have a calculation field (made up of bits of a contact's name) that I would
like to contain unique values.
What is the best way to do this?

I would like to print the contents of a single text field via a script in
FMP7. However the text could span several A4 pages. How do I tell the
printer via the script print command to print all pages. Sounds simple, but
I can't seem to handle the large print job.

I have a simple database with Patient Name, Date, Medicine, and Price.
I want to produce a report that sorts the database by Patient Name and
then by Month and subtotals the Price for each Patient for Each Month.
Simple, huh?  But here is what is not working:

I was wondering whether it is possible to trigger a script depending on the
content of a field within FMP 7.
For example if a text field called "colour" has the drop down value of
"green" selected this could activate a script called "script-green" and if a

My customer is running a full Mac system. Mac Server 2.5, FileMaker Server
6.5. All work stations are running Mac X and FM 6..
I needed to change some access privileges and make some script changes. I
was doing this using remote desktop from one of the work stations. I stopped

I'm using the following to calculate days since a job was entered in the
database:
Get ( CurrentDate )-If (Date1>1/1/1900;Date1;date created)
I want it to calculate days since Date1 if that date is entered, or since

I am trying to label my x axis with a dynamic range I have defined. It
should display stock prices with a line graph over the period of years.
(2002  2003  2004  2005  ) should be displayed at the bottom of my x
axis. I have used vba to create a click event to dynamicly change the

I can open a Word Pro 97 file using the SEND EVENT script (with the relative
path of the file stored in a text field as Account/File1.doc)) as long as I
open the FMPro 7 database within its directory.  If I place a shortcut on
the desktop and open the database the relative file ...

I am stumped how to use a self join to extract a correct information
from the same table. I assume that a self join is the way to do what I
want to accomplish.
I have a table called Firms in which I store information about

I am reasonably familiar with FileMaker, using FMP 7. I know about
making relationships, layouts, showing related fields, making portals,
calculation fields etc.
Problem:

I've spent the last 24 hours trying to get a *very* simple program to
reliably connect to FileMaker 7 via JDBC with little success. After
much wasted time, we we were finally put in touch with a FileMaker
developer who had been advised of a solution by a FileMaker tech. I'm

I've recently deployed FM7 server advanced for testing/development and
can't connect to the hosted database via IWP:
1) I had it working via IWP host by FM7Pro
2) Both defined accounts have "IWP" checked off in extended preferences,

fmp 6.04u, winxp
I'm trying to run a script called "Web Drop" and I've got it as: <a
href="FMPro?-DB=Macrofile.fp5&-Format=jep.htm&-Script=Web Drop&-View">Change-
Drop Yes</a>