Update One table from another table

  • Thread starter Thread starter Mcleaver via AccessMonster.com
  • Start date Start date
M

Mcleaver via AccessMonster.com

I have to create a separate database for an outsource company where the
records are sent to the 'home' database daily. I need to know if it's
possible to update the outsource table from the home table once processing
has been done. Is it possible to have and update query match primary keys and
update the corresponding fields?
 
Yes, its possible with an UPDATE query (look in Access Help).
If the primary keys are autonumbers, however, the primary keys wont
necessarily match.

-
 
Another way to do it, is to "Link" one table to the other. This way, when one
changes the other will update automatically. See Linking Tables. Only thing
here is that all fields get linked.

Cheers...........
 
Back
Top