D
DS
Each Employee can have many jobs
Each Dept can have many jobs
So....I have this
tblEmp
EmployeeID
EmployeeName
tblJobs
JobID
JobName
tblDepts
DeptID
DeptName
tblEmpJob
EmployeeID
JobID
So I connect tblEmp to tblEmpJob
tblEmpJob to tblJobs and
tblJobs to tblDepts
What I need is a One on One relationship between Depts and Jobs but
Access says that this isn't correct. Is there another way to set this
up? Another table or field perhaps?
Thanks
DS
Each Dept can have many jobs
So....I have this
tblEmp
EmployeeID
EmployeeName
tblJobs
JobID
JobName
tblDepts
DeptID
DeptName
tblEmpJob
EmployeeID
JobID
So I connect tblEmp to tblEmpJob
tblEmpJob to tblJobs and
tblJobs to tblDepts
What I need is a One on One relationship between Depts and Jobs but
Access says that this isn't correct. Is there another way to set this
up? Another table or field perhaps?
Thanks
DS