I have two tables in Filemaker. I want to the display only the records that in both tables. I have two tables that have employee ID and Employee Names. I want to be able to display only the records that are not in both tables.
Assuming that you have a relationship between Table One and Table Two based on employee ID.
From Table One
Show All Records
and vice versa