2 Replies Latest reply on Sep 8, 2016 9:47 AM by sfoens

    Find Records in Parent Table Where There Are No Child Records

    sfoens

      I have the following two tables

       

      Fees

      --------------

      FI_ID

      FEE_NAME

       

       

      Permit Fees

      ---------------

      PF_ID

      FI_ID

      PF_AMOUNT

       

      In the relationships window, I have a one to many join from the Fees table to the Permit Fees table based on FI_ID

       

      I would like to perform a Find in a layout that displays a list of rows from the Fees table where there is no corresponding Permit Fees row.  In SQL, it is an outer join and in the WHERE clause, look for rows where the field from the child table is null.  Just cannot figure out how to do this in Filemaker.