How to update values in fields from one table to same fields in another Table

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

Guest

Don't want to append additional records just want values
from fields in Table 2 to Update to values of same fields
in Table 1.

Searching for most efficient way to design a query
that will update changes to fields not add/append values
that have changed from table1 to end of table2. Table 1
and 2 have identical data structure. Table 1 is fact
table contains a list of unique customer numbers (primary
key) and other fields including phone# and fax # fields
that I am interested in maintaining. Table 2 Table 3
etc. will contain partial lists of the customer records
from table 1 some of which have had phone and fax numbers
changed.

What I want to do is run a query that will modify/update
only those fax numbers that have changed in table 2 to the
corresponding fax # field in table 1. Common field in
Table 1 and 2 is customer #.

inside and outside joins don't get me what I want. Update
and append queries don't do what I want.

Help - I want to automate updating
..
 
From what you are describing it seems like your table structures are not
normalized. You should never have duplicate information in one table that
also resides in one or more other tables. This is redundancy and introduces
entity and referential integrity issues. I would read up on normalization
and relationships. Both which can be searched via the Internet.
 
Back
Top