Find records from one table that aren't in another
I am trying to do something fairly simple, but being Friday my concentration level is quite low.. so I need some help.
I have 2 tables: "store" and "import" which are related by the "ID" field. "Store" has a single record per ID, "import" can have multiple records with the same ID. I am trying to find all of the records in the "store" table that are not in the "import" table.
Store contains the following IDs:
My desired result:
What's the best way to achieve this? My original thought was via a relationship...? Thanks!
Edit: Forgot to mention using FMP11