5 Replies Latest reply on Aug 3, 2016 4:41 AM by sudha

    Retrive the ID which is not present in another table


      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.