Show Omitted Only

Finds the records not in the current found set.

Options 

None.

Compatibility 

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

Originated in version 

6.0 or earlier

Description 

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.

Copy
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.

Copy
#With Show Omitted Only, multiple steps are necessary
#to create a new found set, omit the current record,
#and show only the omitted record.
Copy
Show All Records
Omit Record
Show Omitted Only
Copy
#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.
Copy
Find Matching Records [Replace; Invoices::Invoice ID]