Table Design

  • Thread starter Thread starter Sally
  • Start date Start date
S

Sally

I want to create a very basic database for employee phone
numbers. I have 2 tables:
Department & Employees

Department table consists of 2 fields:
Dept.
Dept. No. (primary key)

Employees table consists of 7 fields:
Last Name
First Name
Employee ID (primary key)
Home No.
Cell No.
Pager No.
Work No.

Should I set up a relationship between the 2 tables?
If so how?
Doesn't there have to be a common field in both?

Thank you for your time
 
You can add the field Dept. No. to the Employee's table
as a Foriegn Key. That way you can link the tables.
 
Back
Top