Form Design/Timesheet Creation

[DKF]

Hi everyone.

I am hoping someone will have an idea how to accomplish the following form design issue I am really struggling with:

I need to create a 2 week timesheet for employees. I work for a park district - so my employees work various days and various hours at many locations.

I have attached a sample of the paper form we currently use - it is two sided - one side for each week.

I am struggling with the table structure for the Timesheet - since you don't repeat fields (since I need 2 Sundays, Mondays etc.)
I thought it would look something like:
Timesheet ID = primary key
Employee ID = foreign key
Pay Period
Day 1
Day 2
Day 3 etc - up to Day 14
Vacation Time
Sick Time
OT

But then I get stuck on 2 issues - which are:
How or where do I record all the locations & time each person works each week? To then track on reports at a later date - location reports & employee reports.

How do I program the form to auto-populate all the days of the week (actual dates) based on the pay period selected? We have 26 pay periods each year - so Pay Period 1 is 12/27/09 - 1/09/10 as an example.

Suggestions would really be appreciated - I am so stuck! Thanks.

[Access_Blaster]

Their are some "Time Sheet" databases I did a quick search and found this example I included some screen shots hope this helps.


Regards,

Richard