The purpose of my database is to track employee training. Each employee can work in multiple departments, and each department has multiple procedures. These procedures often overlap various departments, but there is no 'common core' of procedures that everyone is required to take.
I have my tables normalized and the many-to-many relationships set up with junction tables. I've even managed to create a form that updates employee information and which departments they work in.
My problem is that I can't get the employee's procedures to update based on the department(s) I assign. I can add each procedure individually, but that requires running a separate union query for each employee to get the needed procedures without duplicates. And union queries can't be used to update tables.
I've tried to run an update query that references the information I enter into the form, but it keeps saying "0 records updated" no matter what information I change on the form.
I've attached a stripped version of my DB for reference.
All of the information in the DB was imported from the Excel files that we are currently using to keep track of training. The only thing I haven't added yet are the current training dates.
I have my tables normalized and the many-to-many relationships set up with junction tables. I've even managed to create a form that updates employee information and which departments they work in.
My problem is that I can't get the employee's procedures to update based on the department(s) I assign. I can add each procedure individually, but that requires running a separate union query for each employee to get the needed procedures without duplicates. And union queries can't be used to update tables.
I've tried to run an update query that references the information I enter into the form, but it keeps saying "0 records updated" no matter what information I change on the form.
I've attached a stripped version of my DB for reference.
All of the information in the DB was imported from the Excel files that we are currently using to keep track of training. The only thing I haven't added yet are the current training dates.