Design issue

[Leventcos21]

Hello,

I have run into a slight design problem. I am creating a Training database. I have two types of trainings SOP and WI. Each training is a M:M with the employees. Each training has its own Skill Sets and each employee can be assigned M:M skill sets.

Lets say I go into the database and I see that I have SOP training, once it is completed I click the box that it has been completed. However, with my design, it wouldn't let me make any changes, I guess due to my query.

tblEmp --->tblSKillDetail<------tblSkillSet

tblEmp --->tblSOPDetail<-----tblSOP

tblEmp --->tblWIDetail<-----tblWI

tblSkillSet---->SOPSKILL<-----tblSOP

tblSkillSet---->WISKILL<-----tblWI

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Leventcos21]

PHV,

My dilema is that an
employee has M:M skill sets
employee has M:M SOP
employee has M:M WI

also,
Skill sets has M:M SOP
SKill sets has M:M WI