Hi all, I have been stuck on this issue for weeks now and can not find a solution, so I hoping that someone can help me out.
I am setting up a training database. I have setup the structure and started working on the forms and encountered an issue that has me baffeled.
***Table Info****
Employees have skill sets and it is a M:M relationship
Employees have training and it is a M:M relationship
Skill Sets have trainings and it is a M:M relationship
I have a form and I assign each skill set to employee(s). Some employees have multiple skill sets. Then I go into the type of Training (SOP) and assign the skill sets that need to be trained.
**PROBLEM***
Then I go into the employee form and select a certain employee from the list and go into that specfic employee.
The subform has a list of training(s) that employee has to complete. IE
Quality Control ---> The employee gets trained on QC and then completed is selected from the drop down menu. However, the Access DB does not allow it. The query seems as if though it is locked.
I have two intersection tables SkillSet_Details and SOP_Details in that query. When I remove the SOP_Details then my subform is not working.
I can't determine if this is my structure or my query. Please any help will be appreciated. I have attached a screenshot of the relationship
Table Relationship
Access 2003