Reference > Script steps reference > Found Sets script steps > Show All Records
 

Show All Records

Finds all records in the table underlying the foreground window and selects the current record.

See also 

Options 

None.

Compatibility 

 

Product 

Supported 

FileMaker Pro Advanced 

Yes 

FileMaker Go 

Yes 

FileMaker WebDirect 

Yes 

FileMaker Server 

Yes 

FileMaker Cloud 

Yes 

FileMaker Data API 

Yes 

Custom Web Publishing 

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 Advanced 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 

Script steps reference (alphabetical list)

Script steps reference (category list)