Constraining (narrowing) a found set
Constraining a found set lets you narrow find results incrementally, looking for more specific detail as you search your database. To find
records based on multiple criteria in separate
fields (a logical AND search), perform a find, specify the next criteria, then choose
Requests menu >
Constrain Found Set.
For example, after searching for all of the employees who work in Sales, you can narrow the search to find all of the employees within Sales named Alvarez.
To constrain or narrow a found set:
1. Perform a find so that your database contains a
found set.
2. Switch back to Find mode and type the criteria to narrow the search.
3. Choose Requests menu > Constrain Found Set.
FileMaker displays the constrained found set in
Browse mode.
Example
To first search for all the employees in Sales, and then constrain the found set to Sales employees named Alvarez:
1. Perform a find for Sales in the Department field.
2. Go to Find mode and enter a second find request: type Alvarez in the Last Name field.
3. Instead of clicking Find, choose Requests menu > Constrain Found Set.
The found set would then consist of employees in Sales named Alvarez.
Related topics