AnsweredAssumed Answered

list non related records in related tables

Question asked by johngodfrey on Nov 3, 2015
Latest reply on Nov 3, 2015 by ninja

I have two tables, one called Contacts with address, email, etc; and a second table with specific information for some of the Contact records. They are related by = for Name. This works fine.

 

How to list the Contact records that do not have a related record in the second table?

 

Tried a second Contact (TO) table with a Name link that is 'not ='. This showed all Contact records including those with secondary info. I also tried a Layout/Form with a Portal to list Contacts with the 'not =' relationship. This also listed all records.

 

I'm fairly new to FMP and am not yet into scripting. I thought TO's would do what I want. What am I missing?

Thanks

Outcomes