putting tables together

[Dan]

i have 2 tables with basically the same data except for a
few fields are different. for example i have
name,ss#,amount in one and the other i have
name,SS#,amount code in the other i want to put these 2
tables together, but have one line with
name,ss#,amount,Code how can i go about this?

 

[Ravi]

First you need to normalize your tables by riding on the
redundancy yet keeping a key field in both tables that are
the same. Then you need to create a relationship (One to
One or One to Many. Make a copy of your tables table1 and
table2. keep table1 the way it is (name,ss#,amount)then
open table2 in design mode and delete the name and amount
fields leaving SS#,amount code. When you are done, go to
relationship. R-click select add tables (add both
tables). Then click on ss# in table1 and drag it to ss#
in table2. Now you can r-click on the line that shows the
relationship to select one to many, one to one, many to
many. Now you have successfully joined two tables!!!!

Ravi