Finding records > Constraining (narrowing) a found set
 
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.
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.
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. Choose Requests menu > Constrain Found Set.
Related topics 
Extending (broadening) a found set
Finding duplicate values
Finding records based on criteria in a single field