Link Two tables

[Jessica]

I have two tables one call address and the other general information. Both
tables have the following fields in common First Name, Last Name, DOE, Birth
Date, Employee, supervisor and date updated. Is it necessary to have both
fields on the two tables or can i just link them. If could have general
information table with the above fields how do i link it to the address table.

 

[Douglas J. Steele]

No, you shouldn't have the data repeated in both tables. You should have a
primary key that uniquely identifies the row in one table, and just have
that key in the other table. You can then create a table that joins the two
tables.