Combine 2 tables in Access 2000

  • Thread starter Thread starter jbc
  • Start date Start date
J

jbc

Hi,

I have 2 tables that are linked together by a field called
MemberID. Table1 has MemberID as the primary field. When
I originally designed the database, I split the tables up
and now realize that the information shouldn't have been
split. The tables have a 1 to 1 relationship.

What is the best way for me to bring the tables together?
I want to add the fields from Table2 into either Table1 or
create a brand new table. I'm not sure how to approach it.

Table1
MemberID
FirstName
LastName
etc.

Table2
ID
MemberID
miscMembershipInformation fields

want one table with all member information together

Thanks.

jbc
 
Add the fields to one of the tables, and then run an update query on that
table to put the values from the other table (using join) into the
respective fields.
 
Back
Top