What direction should I go next

[lightkeepr]

I have been trying to create a attendance/time-card database for my employees. Attached is what I have so far assembled. What I am curious about next is, what is the best direction to go. I want to be able to track on a two week basis if an employee worked daily all the locations they were assigned and if they did not as an active guard, what substitute filled in for them.

 

[lightkeepr]

What I want to do is be able to enter a start date in a form (IE 9/30/2012) and have generated a table that would contain a listing of each shift in tbl_cg_shifts based off the yes/no checkboxes for Mon, Tue, Wed, Thurs, Fri being checked and that days date being correct. So if the first date is 9/30/2012 (sun) there would be no row generated for any shift. If the next date in the 2 week span is mon 10/1/2012, every shift with the mon box checked would get a row generated with the fields of GuardName, shiftweight, address, shift_time, and school and a new field of GuardWorked (that would default value to the GuardName field)? And have this continue on for the remaining of the 14 day period? Does this make sense? I understand it in my head but I am not sure how to spit it out so others who are better at this than myself can understand it.