Making a find request
To find records, work in Find mode. You type search criteria (the value or values to find) into fields in a find request, which looks like a blank record. When you perform the find, FileMaker Pro searches for records that match the criteria you entered. Matching records replace any previous found set.
To make a find request:
From the Layout pop-up menu, select a layout that contains the fields you want to search for.
If necessary, you can change layouts and enter criteria on more than one layout.
You can use the Insert Operators list in the layout bar to help you enter criteria. For example, the search criteria Jo@n can be used to find the first names John and Joan. See Finding text and characters for more information on using operators.
You can click Omit to exclude records matching a specific set of criteria.
Click Perform Find.
Your find request returns a found set of records.The light green area of the pie chart Pie chart icon in the status toolbar indicates the portion of the total records displayed.
You can click the pie chart to toggle between your found set and the omitted records in the database. When all records are displayed, the pie chart is a solid color.
To access a list of recent finds:
In Browse mode, click the down arrow next to Find (Windows), or click and hold Find (Mac OS).
Cancel a find operation before it is finished and leave the previous found set unchanged
In Browse mode, click Show All, or choose Records menu > Show All Records.
In Find mode, choose Requests menu > Show All Records.
Note  You do not need to choose Show All Records before performing finds. FileMaker Pro always searches all records in the tables you specify unless you have narrowed the existing found set.
Finds on unindexed fields (for example, calculation fields referencing related fields) can take longer than finds on indexed fields. See Defining field indexing options.
To delete recent finds, click the down arrow next to Find or click Saved Finds (Windows), or click and hold Find or click Saved Finds (Mac OS). Then choose Clear All Recent Finds from the list.
Related topics 
Finding text and characters
Finding numbers, dates, times, and timestamps
Finding ranges of information
Finding data in related fields
Finding empty or non-empty fields
Finding duplicate values
Finding records that match multiple criteria
Finding records except those matching criteria
Viewing, repeating, or changing the last find
Hiding records from a found set and viewing hidden records
Constraining (narrowing) a found set
Extending (broadening) a found set
Finding records troubleshooting
Finding records based on criteria in a single field
Saving a find request
Managing saved find requests
Specify Find Requests and Edit Find Request dialog boxes