Show Omitted Only

Finds the records not in the current found set.




Product Supported
FileMaker Pro Yes
FileMaker Go Yes
FileMaker WebDirect Yes
FileMaker Server Yes
FileMaker Cloud Yes
FileMaker Data API Yes
Custom Web Publishing Yes

Originated in version 

6.0 or earlier


Use this script step 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 

Shows all omitted records.

Show Custom Dialog ["Show omitted records?"]
If [Get ( LastMessageChoice ) = 1]
    Show Omitted Only
End If

Example 2 

Demonstrates that using the Find Matching Records script step instead of Show Omitted Only can be a simpler way to create a found set of only the current record.

#With Show Omitted Only, multiple steps are necessary
#to create a new found set, omit the current record,
#and show only the omitted record.
Show All Records
Omit Record
Show Omitted Only
#A single Find Matching Records script step can perform the same task
#when a field with unique values, such as an Invoice ID field, is specified.
Find Matching Records [Replace; Invoices::Invoice ID]