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

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

 

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