Find within a Find

When drilling down to find a specific set of records, you may often find a need to search only within your current Found Set. This feature lets you search sequentially, narrowing your found set as you go. In TradeSchool, this is called Constrain Found Set.

How to Constrain your Found Set

1. Perform a find so that your database contains a found set.

   See How to make a find request.

2. Switch back to Find mode and type in the criteria to narrow the search.

   You can click Omit to exclude records matching a specific set of criteria.

3. Before hitting Perform Find, choose Requests menu > Constrain Found Set.

Example 1

To first search for all Inside Apprentices, then constrain the found set for Apprentices with the last name Smith:

1. Perform a find for "Inside" in the Program field.
2. Go to Find mode and enter a second find request: type "Smith" in the Last Name field.
3. Choose Requests menu > Constrain Found Set

Example 2

To find all active Inside apprentices who have not turned in a March 2023 work report:

1. Perform a find for "Inside" in the program field.
2. Go to Find mode and enter in a second find request: type "3/2023" in the Date field under the Hours tab.
3. Click "Omit" to exclude apprentices who have the March 2023 work report from your found set.
4. Choose Requests menu > Constrain Found Set

Click here to learn about the Search Operators.