Okay, this question will likely appear laughably obvious to many of you but I would be grateful if someone could help me out.
I have a database with a main table (TBL_Main) that requires a Customer Name and Customer Number (p-key). I am linking to an external database/table (tblCustomerData)...