AnsweredAssumed Answered

Cross Reference Table Issue

Question asked by JulioSandoval on Jan 27, 2017
Latest reply on Jan 27, 2017 by philmodjunk

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.

 

Screen Shot 2017-01-27 at 12.23.44 PM.png

 

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.

 

Screen Shot 2017-01-27 at 12.26.16 PM.png

 

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...

Screen Shot 2017-01-27 at 12.27.50 PM.png

Example, if Employee 3, Test is switched to Employee 1, Test, a group of them also change.

Screen Shot 2017-01-27 at 12.28.32 PM.png

 

Thoughts on where I went wrong and better alternatives all welcome.

 

Thank you!

Outcomes