I apologize. The structure above is wrong. it should be as follows: Orders with (simplified) fields OID, CIDFK, LIDFK
with two other tables Customers with Primary Key Cid and Locations with Primary Key LID
I apologize. The structure above is wrong. it should be as follows: Orders with (simplified) fields OID, CIDFK, LIDFK
with two other tables Customers with Primary Key Cid and Locations with Primary Key LID