I have three table to house information about clients and their cases. My client table, tblClaim and tblClaimDetails. So I would have in tblClaim a autonumber ClaimID field with a foreign field ClientID from tablClients. And in tlbClaimMilestones I have autonumber ClaimMilestone with foreign field ClaimID. I want to identify clients where we have failed to complete data in tlbClaim and tblClaimMilestones. So I want all records in tlbClient where the field ClientID does not exist as a foreign field in tlbClaim, and secondly I want all clients where yes we have a record in tlbClaim (field ClientID exists as a foreign field in tblClaim) but a record does not exist in tblClaimMilestones (i.e., a ClaimID value does not exist as a foreign field in tblClaimMilestone). Switching up the join properties does not seem to work.