field accessing another table (1 Viewer)

Z

z5python

Guest
Hi, I am a bit new at access. I work for a Vehicle retailer & am trying to set up a system of records for the vehicles we have for sale. My problem is that the field for the seller (to us) needs to have name, address, contacts etc etc, but in the field I only want
to use this customers id number.
i.e. I think I will have to set up a separate "Customer" table giving each customer a unique ID number.
Am I on the right track or up a gum tree?
 

Users who are viewing this thread

Top Bottom