access tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables that contain similar information, but a different list of
names. I need to combine the two tables so that each name appears, and their
specific data appears. I have tried creating a relationship between them
based on the name field that is in both. But, when I do this not all the
names appear, and the specific data that is relative to each table does not
appear the way I want it to. I know this is a simple question, but I cannot
figure out what I am doing wrong. Any suggestions would be appreciated.

Thank you,
Annie
 
Why don't you copy all the records from the one table into the other and
then delete the first table? Do you need both tables? IF the fields in
each table are the same, the answer is almost always, "No." If one table
contains widgets and the other table contains gizmos, you should add a
"type" field to the records and combine them into one table called
"products" for example.

If the table structure varies, then you probably need both. You might play
around with UNION queries to see if you can get the data you want in one
query.
 
Back
Top