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.