But… Am I wrong or these are fixed shifts? If the end time always coincides with the start time of the next shift, then you could simply relate end time to start time in the same table. In this case, after Steven it would not be anyone’s turn because the relationship would be empty.
1 Like