User manual

3-6 FileMaker Pro User’s Guide
To restore a request to the way it was when you last committed it,
choose Requests menu > Revert Request. Requests are committed, for
example, when you click out of all fields, go to a different layout or
request, or perform a Find.
Finding empty or non-empty fields
Finding duplicates
If you perform a find for duplicate records, the found set of records
depends on the method you use to find them:
1 You can find only the “extra” instances of duplicated records. For
example, you have two records for each customer and you want to
find only the second record for each customer.
1 To do this, choose Help menu > Contents and Index, click the
Index tab, and type Duplicate values.
1 You can find all records that are not unique, not just the “extra”
records. For example, you might want to find all records that aren’t
unique, then examine them to decide which records to use or delete.
1 To do this, choose View menu > Find Mode and type ! in the field.
You determine the field on which uniqueness is based. If several
fields taken together determine uniqueness, you can create a
calculation field (returning a text result) that concatenates the values.
An example formula is First Name & Last Name & Phone
Number.
Keep these points in mind:
1 Values are duplicates only if word order is the same.
1 When determining uniqueness in text fields, FileMaker Pro looks
at the first 20 alphanumeric characters of each word, up to a total of
60 characters (including spaces).
1 You cannot find duplicate values in unindexed fields. Indexing is
documented in Help. Choose Help menu > Contents and Index, click
the Index tab, and type storage.
Finding all records except those matching criteria
You can exclude records while performing a find. For example, you
can find all invoices except those created in the past 30 days.
Finding records that don’t match criteria
For example, to find all sales records except those for the city of
London:
1. In Find mode, type criteria for the records to omit.
2. Select Omit.
3. Click Find.
To find fields that are Enter this in the field
Not empty (i.e., fields that have data) *
Empty =
C
li
c
k
a page o
f
t
h
e
b
oo
k
to
see another find request
Number of the current request
Number of existing requests
Select Omit to
exclude records that
match the request