Merge Data

[montanan]

I have worked with many contact management programs but access is new to me. I have a table of over 1,000 contacts with fields firstname, lastname and city. I have another table of over 10,000 contacts with the fields firstname, lastname, city, address, zip and phonenumber. I'd like the table of 1,000 to include addresses, zip and phonenumber from the second table.



Thanks for your help!

[June7]

These are different data - not the same lastname, firstname, city combinations in both tables? You need a dataset of 11,000 records? Is this a one-time action? Can simply copy/paste the 1,000 records into the other table.