User manual

3-2 FileMaker Pro User’s Guide
Choose a
Type Find criteria in fields
layout with
fields you want
to search on
Click the
down arrow
to see the
operators
Click to begin
searching
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:
• In Browse mode: choose Records menu > Show All Records.
• 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:
• 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.
• Finds on unindexed fields (for example, calculation fields
referencing related fields) can take longer than finds on indexed
fields.
• 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.
To find Type this in the field Example
Words that start with The characters. Chris Smith finds
specific characters Chris Smith, Smith Chris,
Chris Smithson, and Smith
Christenson
A phrase or sequence of The text, including "Marten and Jones
characters spaces and punctuation, Interiors" finds
between the double Marten and Jones
quotation marks ("). 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 One wildcard character Gr@y finds Gray and Grey
unknown or variable (@) for each unknown
@on finds Don and Ron
characters character.
but not Bron
Words with zero or more * for all unknown
unknown or variable text characters.
J*r finds Jr. and Junior
characters in a row
Jo*n finds Jon and John