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

Y

Yakub

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?
 
D

Duane Hookom

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.
 
Top