I am trying to build a database by MS access 2010 for Animal Import Control Ports. I have three tables names are: Importers, Consignments, Staff, and one table named tbgroup (ID, importer ID, consignment ID, and Staff ID).
The problem is when I relate the primary key (the IDs) of each table...