Save Searches

[Paul Guelpa]

Hello, I'm very new to FileMaker and I want to know if there is a way that you can do a search, and then save the results that it returns. Also if there is a way you can save the conditions the search is based upon so you can quickly do the search again and get an updated list of results.

Thanks for anyone who can help.

Cheers,

Paul

[The Shadow]

If you perform the find manually, then immediately go to "ScriptMaker..." under the scripts menu.

Make a new script, and select the "Perform Find" step, click on "Specify Find Request" and you'll see your last find is already stored there.

Click okay all the way out, now you have a script that performs a find with the conditions you used.

Saving the result itself is trickier, the easiest way IMO is to export a unique field from the found set, then you can import it later, updating matching records - that will reproduce the original found set without re-doing the search.

[Reed]

There is a good technique for saving a found set this week at www.filemakermagazine.com

Dana

[Vaughan]

I have never done a solution that saves found sets. However, one of the challenges that I have is how to handle cases where a record in the found set is deleted, or a new record is created that would have been in the found set.

Just food for thought, no answers I'm afraid.