U.M. (Mac OS)

Working with information in records 4-19
Finding information
You find specific records using Find mode. In Find mode, you can get a
subset of the records in a file (called the found set) to do the following:
1 Get specific information based on the data in text, number, date, time,
and calculation fields.
1 View, edit, perform functions on, calculate summaries for, sort, print,
delete, export, or copy the found set to a different file.
1 Find records that contain errors like empty fields, duplicate values,
invalid dates or times, or mistakes you might notice (like
misspellings) while viewing the index.
1 Further reduce the found set by omitting records from it.
To find records, you type criteria (the value or values to find) into fields
in a find request, which looks like a blank record. FileMaker Pro
searches through all the records to compare the criteria with the data in
the file. Records whose fields match the criteria are added to the found
set, and the found set becomes the records being browsed.
Find requests can be as simple or complex as required, from a single
request for a name in a field to multiple requests using operators and
omissions.
Defining find requests
1. Choose the layout to use for finding records.
The layout must include each field you plan to enter criteria into.
2. Choose Find from the Mode menu.
3. In the find request, select the field to use for finding, and then type
values in the field.
You can combine values you type with operators from the Symbols
pop-up menu.