Merging Two Tables

[RSS705]

Hello there!

I need to merge two tables together, but not create new rows of data.

So for example, I will have a table provided to me with the following information for one entry: Individual ID number (table key) and the Individual's Name.

I will then need to populate the unknown data (the Individual's address and contact information) from a master dataset (another table in Access), based upon a matching Individual ID number.

Is there a way to complete the Individual's missing data, rather than creating new rows?

Thanks!

 

[GinaWhipp]

You should be able to run an UPDATE query to update the fields that blank by linking on the Individual ID and Individual Name fields. You might need to run it for each field so that you can only run for fields that are blank. Something like...

UPDATE Table2 INNER JOIN Table3 ON (Table2.IndividualName = Table3.IndividualName) AND (Table2.IndividualID = Table3.IndividualID) SET Table2.Address = [Table3]![Address];

 

[RSS705]

Hi Gina,

Thanks for your reply, I'm relatively new to Access so will need to work on my query for a bit. Hope it works!

 

[GinaWhipp]

Okay, but remember, work on a copy first to make sure nothing goes wrong!

 

[Mihail]

Seems to be a 1-1 relationship between this tables.
Why you not store all the information in a single table ?
On the other hand, by copying the information from one table to other you will break the rules of normalization.