Update Query

  • Thread starter RIDEMNSLIDEM via AccessMonster.com
  • Start date
R

RIDEMNSLIDEM via AccessMonster.com

I have 2 tables. Table 1 is customer (name, address, customer #) with
expiration year 8, 9 & 10. In Table 2 is customer # and other data. I am
wanting to add the expiration year column to Table 2. How can I setup an
Update Query by customer # and have the expiration transfer from Table 1 to
Table 2? Table 2 has multiple lines entered per Customer #. Thanks
 
D

Duane Hookom

Can you provide some specific table and field names? The tables need to be
related by primary and foreign key fields. Can you tell us this information
also?

Do you want to update every related record in table 2? Why even do this if
the information is already stored in table 1?
 
Top