FileMaker 10 Saved Finds (Constrains And Extend Routines)

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

There are some situations in which the new FileMaker 10 Saved / Recent finds might have troubles covering you. These situations are pretty complex however and I’m not sure how often you would run into this out in the field.

You see, it is challenging sometimes to communicate all the great things that FileMaker searches can do. As a longtime developer and a person that has written about the found set quite a bit ... I still uncover unique combinations on a regular basis.

I’ve had mixed success in spreading the gospel of constrain and extended finds to users. Some folks really get it and some just do not. The below FileMaker 10 saved search limitation would involve someone ...

- implementing constrain / extended finds regularly
- immediately grasping FileMaker 10 saved search feature
- immediately trying to blend the two

If you perform a find, get a found set and then perform a constrain/extend find, FileMaker does not track both of those search processes as one saved find. This makes a lot of sense when you think about it. How would FileMaker know these two independent finds should be combined and saved as a recent find?

The trick (when possible) is to integrate both process within a single find and you are good to go. Multiple find requests in a search allows you the option to make your search more robust. For example, what if you want to find records that match one thing but you want the found set to not contain something else.

Similar to the task of creating new records in browse mode, you can create new find requests in find mode. The first request in the request order runs first and following requests in line after that.

Many users don’t utilize multiple find requests because they don’t know or are not comfortable in using them. However, after you get a few successful multiple request searches under your belt, you may find that you use them all the time.

Here you can see the Requests menu, only available when you are in find mode. You can see the add, duplicate and delete request options. Much like what you can do when working with records in browse mode!

© 2010 - Dwayne Wright -
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.