User manual

3-2 FileMaker Pro User’s Guide
4. Click Find in the status area, or choose Requests menu > Perform
Find.
To cancel before searching is finished and leave the previous found
set unchanged, press Esc (Windows) or Command+period
(Mac OS).
After performing a Find, you can change or refine the criteria. See
“Viewing, repeating, or changing the last find” on page 3-7.
To show all the records again:
1 In Browse mode: choose Records menu > Show All Records.
1 In Find mode, choose Requests menu > Show All Records.
You don’t need to choose Show All Records before performing finds.
FileMaker Pro always searches the entire database.
Keep these points in mind:
1 You can’t enter search criteria in container fields, summary fields,
or global fields. To find data in container fields, create a text or
number field that describes or identifies the contents of the container
field. Then find the value in the text or number field.
1 Finds on unindexed fields (for example, calculation fields
referencing related fields) can take longer than finds on indexed
fields.
1 If a field’s values are indexed, you can use the index to enter values
in find requests. Using the index is documented in Help. Choose Help
menu > Contents and Index, click the Index tab, and type storage.
Finding text and characters
Search for text in text fields, or in calculation fields that return a text
result.
Except as noted, when you search for text, the field can contain other
values in addition to the one(s) you specify, and the values can be in
any order. For example, typing hotel in the Accommodation field
finds records for Hotel, Discount Hotel, and Hotel, Luxury.
Click to begin
searching
Click the
down arrow
to see the
operators
Type Find criteria in fields
Choose a
layout with
fields you want
to search on
To find Type this in the field Example
Words that start with
specific characters
The characters. Chris Smith finds
Chris Smith, Smith Chris,
Chris Smithson, and Smith
Christenson
A phrase or sequence of
characters
The text, including
spaces and punctuation,
between the double
quotation marks (").
"Marten and Jones
Interiors" finds
Marten and Jones
Interiors but not Jones
and Marten Interiors
", Ltd." finds all
companies with ", Ltd." in
the name, but not those
without the comma.
Words with one or more
unknown or variable
characters
One wildcard character
(@) for each unknown
character.
Gr@y finds Gray and Grey
@on finds Don and Ron
but not Bron
Words with zero or more
unknown or variable text
characters in a row
* for all unknown
characters.
Jo*n finds Jon and John
J*r finds Jr. and Junior