Show All Records
Purpose 
Finds all the records in the table underlying the foreground window and leaves you in the current record.
Format 
Show All Records
Options 
None.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server scheduled script 
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; No dialog]
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; No dialog]
Related topics 
Script steps reference (alphabetical list)
Script steps reference (category list)