how can you have access fill customer name based on ID?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several tables in my database with ID number as a common fiels for
the customers. How can I make access fill in customer first and last names
automatically if I just put customer ID?
 
You should not generally store the first and last names in more than one
table. You can use a query that joins your customer table to related tables.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Customized ID Nos 15
New Database 4
Filling in voids in the id number 4
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Complete Idiot Here... Help 3
Age Validation 1
one-to-one relationship problems 9
Access 2002 Data entry combo box or list box 3

Back
Top