Doing a Single-Criterion Search

If you need to find every instance of just a single item, use the single-criterion search.

To do a single-criterion search

1.	You can't search for information in a particular field unless you have a layout with that field in it. Switch to the layout of your database that contains the field or fields you want to search.
2.	Once the correct layout appears, choose View > Find Mode (Figure 5.2). Or use your keyboard: (Windows) or (Mac). A blank version of the selected layout appears. Figure 5.2. To start a search, choose View > Find Mode.
3.	In our example we want to find all the houses on Pomona Avenue, so type Pomona into the Street Name field (Figure 5.3). Click the Find button in the mode status area along the left-hand side of the screen (Figure 5.1), or simply press (Windows) or (Mac). (You can also choose Requests > Perform Find but using the keyboard is much easier.) Ten records appear that contain "Pomona" in the Street Name field (Figure 5.4). Notice that the left-hand mode status area shows the number of found records (10), along with the total record count (32). Figure 5.3. Type into any field the data you're seeking. Figure 5.4. Once you click Find, FileMaker displays any records matching your search.

Tip

• Once you find a set of records, you can copy their data into another application, such as a spreadsheet, though FileMaker's field formatting will not be copied. Just use the Copy command: (Windows) or (Mac).