Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 121
Related topics
Finding duplicate values
Viewing, repeating, or changing the last find
You can view, repeat, or change a recent find request.
To view or repeat the most recent find criteria:
• In Find mode, click Saved Finds in the status toolbar, and choose a find request from the
Recent Finds list.
• In Browse mode, click the down arrow next to Find (Windows), or click and hold Find
(OS
X). Then choose a find request from the Recent Finds list.
To change the most recent find criteria:
1. In Find mode, click Saved Finds in the status toolbar, and choose a find request from the
Recent Finds list.
2. Modify the criteria.
3. Click Perform Find to perform the find using the criteria.
Note In Browse mode, you can also change the most recent find criteria by choosing Records
menu
> Modify Last Find.
For information on viewing and changing a saved find, see Saving a find request.
Hiding records from a found set and viewing hidden records
All records that are not in the found set are omitted, or hidden. You can omit additional records from
the found set without doing a new find.
Important Omitted records are temporarily excluded from the found set. They still exist in the
database.
Related topics
Finding records except those matching criteria
To Do this
Omit a specific record Display or select the record to omit, then click Omit in the layout bar. You can
also choose Records menu > Omit Record.
Omit a series of
records
Display or select the first record in a number of consecutive records to omit, then
choose Records menu
> Omit Multiple. In the Omit Multiple dialog box, type the
number of records to omit, then click Omit.
View the omitted set Do one of the following:
• Click the pie chart in the status toolbar.
• Choose Records menu > Show Omitted Only.
Bring back all the
records in the file
In Browse mode, click Show All in the status toolbar.
In Find mode, choose Requests menu > Show All Records.