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.
|
1.
|
|
2.
|
|
3.
|
In the find request, select a text, number, date, time, timestamp, or calculation field to use for finding, and then type a value in the field.
|
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.
|
4.
|
Click Perform Find.
|
in the status toolbar indicates the portion of the total records displayed.|
•
|
You can see the last several find requests you have performed in a Recent Finds list.
|
|
•
|
In Find mode, click Saved Finds.
|
|
•
|
|
2.
|
Choose a find request from the Recent Finds list.
|
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 (OS X). Then choose Clear All Recent Finds from the list.
|
indicates a searchable field.