CALENDER TABLE

[diggermf]

Hi All,

I want to store the hours worked against a particular task on a daily basis for every month & year.
Just like the daily time sheet.

for example:

1. Task1 - 3 hrs on 1st jan'08
2. task2 - 5 hrs on 1st jan'08
3. task1 - 4 hrs on 2nd jan'08
4. task3 - 4 hrs on 2nd Jan'08

Could some one please guide me on how to create a calender table such that i can record the hours on the daily basis for all the tasks.

Thank you

 

[straybullet]

perhaps something along the lines of:

tblTask
TaskID <-primary key
TaskDescription

tblWorker
WorkerID <-primary key
FName
LName
etc.

tblWorked
WorkedID <-primary key
TaskID <-foreign key to tblTask
WorkerID <-foreign key to tblWorker
DateWorked
HoursWorked

Queries can then be used to display the desired combinations of Task, Worker, and Hours.

Let them hate - so long as they fear... Lucius Accius