Show All Records
Purpose
Finds all records in the table underlying the foreground window and selects the current record.
See also
Format
Show All Records
Options
None.
Compatibility
Where the script step runs | Supported |
FileMaker Pro | Yes |
FileMaker Server | Yes |
FileMaker Go | Yes |
Custom Web Publishing | Yes |
FileMaker WebDirect | Yes |
Runtime solution | Yes |
Originated in
FileMaker Pro 6.0 or earlier
Description
Use this script step to redisplay all the records after working with a
found set.
Use Show All Records in Browse mode or Preview mode. If you perform this script step in Find mode or Layout mode, FileMaker Pro switches to Browse mode after the records have been found.
Example 1
Goes to the Invoices layout, shows all records, and performs a sort.
Go to Layout [“Invoices”]
Show All Records
Sort Records [Restore; With dialog: Off]
Example 2
Performs a find, shows all records if no records were found, and sorts the found set.
Perform Find [Restore]
If [Get (FoundCount) = 0]
Show All Records
End If
Sort Records [Restore; With dialog: Off]
Related topics