Forum Discussion
1) Resets are recorded in the reset table, the ResetID is a text formula field and is used as the reference proxy to the travel table.
2) Associates are recorded in the associate table
What is happening a manager after scheduling the reset will schedule associates to work the project. Say at store 123, Joe is working 6/12 thru 6/24. Then the manager will schedule Joe again at store 456, from 6/19 thru 6/24. So, there is an overlap or double scheduling happening that I need to eliminate.
2) Associates are recorded in the associate table
What is happening a manager after scheduling the reset will schedule associates to work the project. Say at store 123, Joe is working 6/12 thru 6/24. Then the manager will schedule Joe again at store 456, from 6/19 thru 6/24. So, there is an overlap or double scheduling happening that I need to eliminate.