Retrive the ID which is not present in another table

Discussion created by sudha on Aug 2, 2016
Latest reply on Aug 3, 2016 by sudha

Hi all,


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.