Creating db with relationships

[superrob5]

I have a table that has user information
EmpID
FirstName
LastName
Site
Phone
Voicemail
Modem


then I have a table that will hold the cell phone list. which consit of
EmpID
CellNumber
Model
SerialNumber
Active
DateAssigned

This would be a 1 to many relationship but not sure what I should do to make it. I can only make it one to one for some reason.

 

[pcEars]

No problem setting the relationship on my machine

 

[pcEars]

depends on your needs

If EmpID has only 1 or 2 cell phones at any given time, the tables should likely be combined

If EmpID is the salesman selling many phones, probably best as is

 

[superrob5]

k I changed I realized that I need to have a primary key in the cell table. Can you look and tell me what you think I should do to improve if needed.

 

[jeremie_ingram]

The problem is the EmpID is the primary key in both tables. You need to tke the Primary Key settings off of the EmpID field in the table CellPhone. If this table will require a primary key, just add in another autonumber field.

You have it set up right except for that one point. If you try to relate 2 primary keys, it has to be a one to one relationship.

 

[superrob5]

I am getting an errror when trying to relate a table, enforce referential integrity are violated on the many side of a relationship what does that mean exactly.

Rob