If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combine 2 tables in Access 2000
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 |
#2
|
|||
|
|||
Combine 2 tables in Access 2000
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. -- Ken Snell MS ACCESS MVP "jbc" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access License In Terminal Server | JIM.H. | General Discussion | 9 | July 19th, 2004 12:32 AM |
SQL Server 2000 Stored Procedures to MS Access 2000 Queries | CS | General Discussion | 4 | July 15th, 2004 03:27 AM |
Access 2000 - creating pivot tables | ingra | General Discussions | 1 | July 9th, 2004 08:43 PM |
Access 2003 | RK | General Discussion | 12 | June 14th, 2004 10:16 AM |
Access 97 & Access 2000 | Wnder | General Discussion | 2 | June 11th, 2004 12:35 AM |