CATEGORY: Found Sets
CLASS: Basics
The action of a constrained find is like a find within a found set. It is a way to narrow down your search results, after you have already performed a successful search. The way it works is when you are in find mode, a new menu option becomes available. It is called Requests and contains the constrain found set option. You won’t see this option in Browse, Layout or Preview modes. The constrain found set option is like starting with a very wide search. After looking at your resulting found set, you can then use Constrain Found Set to narrow down the results even further. To get a constrained find to work properly, you first need to perform a successful find, do a GTRR, omit a record or anything that gives you a found set less than the overall record count for the table.
This can be used as a way to drill down to more specific results after a find. For example you could do a find for customers assigned to a sales rep. Then you can do another find within that found set for those customer assigned to a sales rep and reside in a particular state. After doing the first find, choose to do a find, enter in your extra find data and make sure the constrain found set option is selected before you perform the find.
Here are some links to other posts that might be of interest in regards to this topic...
The Constrain Found Set Script Step
EXAMPLE: Constrain Found Set
EXAMPLE: Constrain Sans The Find
Audio Comment About Episode 20 Of FileMaker Success Tips
ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit http://www.dwaynewright.com/donate.html
Posts
