List records that do not appear in linked table

[nsl]

I have two tables, the master table has records with an Id that links to a sub table via the Id. The master record can have 0-4 records in the sub table, I want to list all records from the master table that do not have any records in the sub table.

[-Queue-]

Create a calculation field in the master table of

IsEmpty(relationshipToSubTable::serial)

then search for 1 in this field.

Alternately, you can

Freeze Window

Show All Records

Go to Record/Request/Page [First]

Loop

If [isEmpty(relationshipToSubTable::serial)]

Go to Record/Request/Page [Exit after last; Next]

Else

Omit Record

End If

Exit Loop If [not Get(FoundCount)]

End Loop