military watchbill creator

[ddecker3]

I am trying to create an automated watchbill creator.

Watches (for those that dont know they can be treated like shift work).
We stand 2 differant watchs a day.
8 hours watchs. 1 starts @ 1600., 1 starts @ 0800.
We are in 4 sections - so that mean each section has about 20 people.
10 that can stand the first watch, and 10 that can stand the second watch.

Currently I have 3 tables
Personel, Excuse Log, Watch

Personel
SSN (Last4)
Last Name
First Name
Rate/Rank
Duty Section
Watch (watch they stand) (sdo, dd)

Excuse (its basically for people who are on leave, school, ect)
SSN
LastName
Watch
StartDate
Enddate

Watchs. (this one I am not to sure how to do.)
right now I have
StartDate
Starttime
SDO_Personel
DD_Personel


I have input all the users in the personel table.
Which is great for right now, setup basic query for duty section, watchs they can stand.

What I wanted to do was have it autogenerate a watchbill for each duty section. So 4 sections requiring 5 people per day. Dont know how hard that is, or feasible by myself.

I hope I explained it as best as I could.