Combine 2 tables in Access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jbc - 02 Aug 2004 21:27 GMT

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

Reply to this Message

Ken Snell - 03 Aug 2004 01:01 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> Hi,
>
[quoted text clipped - 24 lines]
>
> jbc

Reply to this Message