sfoens

Find Records in Parent Table Where There Are No Child Records

Discussion created by sfoens on Sep 7, 2016
Latest reply on Sep 8, 2016 by 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.

Outcomes