User manual

Chapter 3
Finding and sorting information
This chapter shows you how to:
1 find records in your database using many different criteria
1 omit records from the found set
1 sort records
Finding records
To find records, work in Find mode. You type 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 through
all the records, comparing the criteria with the data in the file.
Records with data matching the criteria are added to the found set,
which is the subset of records being browsed.
You can then work with just the records in the found set. For
example, you can view, edit, calculate summaries for, sort, print,
delete, export, or replace data in these records.
To define a find request:
1. Go to a layout that has fields you want to enter criteria in.
You can change layouts and enter criteria on more than one layout.
2. Choose View menu > Find Mode.
3. In the find request, select a text, number, date, time, or calculation
field to use for finding, then type a value in the field.
See the following sections for how to enter special criteria. For
example, you can search for:
1 text, symbols, numbers, dates, or times
1 exact matches
1 ranges of information
1 invalid dates or times
1 data in related fields
1 records that match multiple criteria
1 empty or non-empty fields
1 duplicate values
1 all records except those matching criteria you specify
You can use the Symbols pop-up menu to help you enter criteria that
include operators.
The number of records in
the current found set