There are two tables named "PL" and "CH".
There is a column 'CHID' which is present in both the tables.
When ever a new record is created the in table PL , it will use the CHID from the CH table. At some point of time, few of the CHID 's are deleted in the CH table . However, the ID's are still present in PL table.
Now, I want to take the list of ID's from PL which are not present in CH. Can you please help me on how to achieve this in Filemaker.