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.
See Making a find request.
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 
Extending (broadening) a found set
Finding duplicate values
Finding records based on criteria in a single field
Was this topic helpful? Send feedback.