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?