Link Two tables

J

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.
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top