I have a Unit table with each of our locations and a vendor order history table for each vendor.  Each vendor has a customer or ship to number for each of our locations (units)and I have stored the vendor's customer number in my Unit table.  Can I use that vendor customer number in my Unit table instead of my primary key (UnitID) as the primary key? And relate it to the customer (Ship to) in my vendor table as the foreign key?

---

Reply from Alex Hedley:

You can, or you could just join the multiple tables with a Query to get the info you need, or use DLOOKUP.