Hi,
I have a part built DB for a Warehouse Rota team
Days - 7 week rolling pattern
Nights - 5 week rolling pattern
Team manager - 16 week rolling pattern
I'm not sure how to connect them together?
They all share one common denominator - Week commencing Sunday date (01/01/2017,08/01/2017 etc. etc.)
How do I align 3 shift patterns together in a table of different rotation week cycles of 7, 5 and 16 weeks.
Any help would be appreciated, i have attached a few screen shots and the DB itself.
Some tables and forms are for testing out purposes (Trial and Error)
Only focus on the DB Relationship tables and the main rota form.
Thanks