field accessing another table

  • Thread starter Thread starter z5python
  • Start date Start date
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

Back
Top Bottom