User manual

32 FileMaker Pro User’s Guide
Deleting and reverting requests
To delete a request, go to the request you want to delete, then choose
Requests menu > Delete Request.
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.
Viewing, repeating, or changing the last find
To view the most recent find criteria, choose Records menu > Modify
Last Find
. Then, to return to the found set, choose View menu > Browse
Mode
. To repeat the find, click Find. Or you can modify the find
criteria, then click
Find.
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.
Finding and replacing data
As in a word processing application, you can find and replace data
across multiple fields (including related fields) in a record or in a find
request, across a found set of records or find requests, or across text
objects in a layout. You can search for data in any type of field except
container fields and fields that are not modifiable.
If you have added a tab control to a layout, when you find and replace
data in Browse and Find modes, FileMaker
Pro only finds and
replaces data in the tab panel that is in front. In Layout mode,
FileMaker
Pro finds and replaces data in all tab panels.
1. In Browse, Find, or Layout mode, choose
Edit menu > Find/Replace > Find/Replace.
2. In the Find what box, type the data you want to search for. In the
Replace with box, type the replacement data.
You can’t replace data in fields that are formatted as pop-up menus,
radio buttons, or checkboxes. These fields will be counted and
reported as skipped at the end of a
Replace all operation.
3. Set the search options you want to use.
To Do this
Omit a specific record Display or select the record to omit, then 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 Choose Records menu > Show Omitted.
Bring back all the
records in the file
Choose Records menu (Browse mode) or Requests
menu (Find mode) > Show All Records.
Select To
An option from the
Direction list
Choose the search direction: Forward, Backward, or
All.
Match case Search for only those occurrences in which the
capitalization matches the data you specified in the
Find what box.
Note In files that contain Japanese data, a find with
the Match case option cleared does not
simultaneously find both the half-width and full-
width version of the same character. To
comprehensively find and replace both characters,
make sure you perform separate finds for both the
half-width and full-width character.
Match whole words only Search for only those occurrences that are whole
words or are bounded by spaces and/or punctuation
characters.