Home > Reference > Script steps reference > Found Sets script steps > Show All Records
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 RecordsSort 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 RecordsEnd IfSort Records [Restore; No dialog] Related topics Script steps reference (alphabetical list) Script steps reference (category list)