Help me define the relationships

[Johnny]

Overtime sign up database.

So one DATE can have multiple blocks of overtime available (05-0700, 07-0900 etc) and each HOUR BLOCK can have multiple employees compete to work it.

Who wins the overtime block on any particular day depends on their previous hours worked in the case of a tie senority determines winner, not that it has anything to do with the table for now but in case that helps any of you understand the workflow.

Sample db included if it helps. I got the one to many from Date to Hours but I can't figure out how to link the signup table to hours correctly, I may need a junction table and I haven't figured out the connection.

 

[michaeljryan78]

I don't know if you have already gotten the answer to your question, but it is quite simple. In the table tblHours, add EmpID and create a one to many with tblEmployee (with tblemployee.idEmpTbl There is the junction.

Hope this helps!