I currently have a problem with trying to assign two employees to one record.
I have an employees table, and I also have an employee type table.
These two tables are part of a cross reference table.
The cross reference table is linked to a scheduling table.
Lets say I have an Inspector Type and Outreach Type of employees.
Each does a different thing.
They are assigned to tasks and each one does something differently in said task.
Assigning an inspector is no problem. One inspector to each task.
I created a separate cross reference table for the Outreach Type employees.
The employee table and employee type tables are the same for both.
The only difference is the cross reference table.
My main issue is, when I assign an outreach personnel to records related to each other, a few of them assign said employee to the others...
Example, if Employee 3, Test is switched to Employee 1, Test, a group of them also change.
Thoughts on where I went wrong and better alternatives all welcome.