Show Omitted Only
Purpose
Finds the records not in the current found set.
See also
Format
Show Omitted Only
Options
None.
Compatibility
Where the script step runs | Supported |
FileMaker Pro | Yes |
FileMaker Server | 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 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]
Related topics