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.