User manual

Chapter 2 | Using databases 43
4. Click one of the buttons to perform the type of find/replace operation you want.
Keep the following points in mind:
1 If you have added a tab control or slide control to a layout, when you find and replace data in
Browse and Find modes, FileMaker Pro only finds and replaces data in fields on the front-most
panel. In Layout mode, FileMaker Pro finds and replaces text on all panels.
1 Performing a find and replace that includes fields on a popover opens the popover.
For more information about finding and replacing data, see Help.
Sorting records
FileMaker Pro stores records in the order they were added to the file. Sorting temporarily
rearranges records, so you can view, update, or print them in a different sequence.
You choose the fields whose contents you want to sort by. The first sort field arranges the records
based on the field’s contents. The second sort field arranges records when two or more records
have the same value in the first sort field, and so on. You can sort records in ascending order,
descending order, or in a custom order.
By default, the records remain sorted until you perform a find or sort records by different criteria.
When you add or change a record in a sorted found set, the record appears in the correct position
in the sort order after you commit the record.
To sort the records in the current found set:
1. In Browse mode, click Sort in the status toolbar.
Note To sort records in Table View in Browse mode, see “Working with records in Table View”
on page 30.
2. In the Sort Records dialog box, choose fields for sorting, in the order you want them sorted by,
and sort options.
To choose a sort field visible on the current layout, no matter what table it is in, choose Current
Layout (LayoutName) from the table list, then double-click a field in the list.
To choose a sort field that is in the current layout’s table, whether or not it is on the current layout,
choose Current Table (TableName) from the table list, then double-click a field in the list.
For information about sort options, see Help.
Click To
Find Next Search for and select the next occurrence of the Find what data.
Replace & Find If there is selected data that matches the Find what data: Replace the Find what data
with the Replace with data, search for and select the next occurrence.
If there is no selected data that matches the Find what data: Search for and select the
first occurrence of the Find what data.
Replace Replace the Find what data with the Replace with data.
Replace All Replace all occurrences of the Find what data with the Replace with data.
At the end of the Replace All operation, you see a summary of the number of
occurrences found and replaced.