Table Design

[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

 

[AFS]

You can add the field Dept. No. to the Employee's table
as a Foriegn Key. That way you can link the tables.