Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 107
Notes
• Performing one of the find commands creates a new find request and deletes any existing
set of requests associated with the current window.
• The find shortcut menu items are only available if you are allowed to enter the field being
used for the find. See
Allowing or preventing entry into fields.
• In Browse mode you can save the find for future use. See Saving a find request.
• If you don’t have the correct privileges to perform the find, the find commands on the
shortcut menu are disabled. See
About accounts, privilege sets, and extended privileges.
• The find commands on the shortcut menu are disabled if a script is running, but has been
paused.
• If the field type selected does not support finds (for example, summary fields, container
fields, and global fields), the commands on the shortcut menu won’t appear.
• If no records match your selected data, an alert box appears. Click Modify Find to go to
Find mode and correct your search criteria. Click Cancel to return to Browse mode; the
found set won’t be changed.
Related topics
Finding records that match multiple criteria
Constraining (narrowing) a found set
Extending (broadening) a found set
Making a find request
To find records, work in Find mode. You type search 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
for records that match the criteria you entered. Matching records replace any previous found set.
To make a find request:
1. Switch to Find mode by clicking Find in the status toolbar.
2. From the Layout pop-up menu, select a layout that contains the fields you want to search
for.
If necessary, you can change layouts and enter criteria on more than one layout.
3. In the find request, select a text, number, date, time, timestamp, or calculation field to use
for finding, and then type a value in the field.
You can use the Insert Operators list in the layout bar to help you enter criteria. For example,
the search criteria Jo@n can be used to find the first names John and Joan. See Finding text
and characters for more information on using operators.
You can click Omit to exclude records matching a specific set of criteria.
4. Click Perform Find.
Your find request returns a found set of records.The light green area of the pie chart in the
status toolbar indicates the portion of the total records displayed.
Tips
• You can click the pie chart to toggle between your found set and the omitted records in the
database. When all records are displayed, the pie chart is a solid color.