FileMaker Example: Saving Found Sets Of Data

THIS TECHNIQUE has withstood the test of time:  Dwayne Wright’s Save Found Set routine makes use of error checking, lists, and multiple line keys to restore a found set of records by ID.  This could come in handy if you are required to keep historical reports for a particular found set – new records added that might fall into a normal find would not show using this technique:

The restore found set script starts by going to the related file in the sets file. We use the name of the set as our relationship. Then we run a script in the set file that goes to the related records in the main file … using the key field data we pasted in during the save found set scripts. This data is a multiple line key field using carriage returns between the key field values.

The use of advanced techniques in this example will require some study–thankfully there is a downloadable example file.  Dig in!

Dwayne Wright PMP, PMI-ACP, CSM – FileMaker Thoughts – FileMaker Example: Saving Found Sets Of Data.