I am trying to write a script that does the following:

1. Filemaker searches through about 4,000 records and returns x number of unique alphanumeric category numbers that are contained within the same field on each record. (This is as far as I have gotten).

2. Filemaker then uses this criteria to perform several searches. But it must print out each the results of each criteria search before moving on to the next search. The script needs to be set up in such a way so that as new categories are added, I don't have to go back and redefine the script.

To give a little more background, the database is a collection of photographs archived according to a catalog number which is determined by client, date, and picture number. But I am trying to print out groups of pictures based on the client only. I currently have over 300 different clients in the database and new ones will be continually added. When the list was smaller I did not mind searching for a client, printing out the pictures, searching for another client, printing out the pictures, etc... But now this would take several days.

Any advice would be greatly appreciated.

If you are doing this for all clients, why do you need a find at all? Why not print one report subsummarized by client? There must be something your're not telling us.

If all you have is catalog number, why not calculate a field that gives you client?

-bd

Good point. I have never learned how to print a report subsummarized by client, though; but this is exactly what I am trying to do. How do I go about it?

Regards,

M.

The short answer is 1) a layout with a Subsummary Part, 2) records with a sort order matching Subsummary Part "sorted by", and 3) Summary fields for totals. Time to hit the FM manual.

-bd