Hi there



I have been racking my brains for the last couple of days for the best solution to this design issue, I hope somebody can help.

I am trying to build a Resource/Timesheet database.

I have a number of users that need to input time spent on specific pieces (per hour of each day, a bit like billable hours) of work, that is no problem.

I have a manager that needs to assign pieces of work to the resources as a percenatge of the time available to each of the resources.

Staff A - Task A 60% Task B 40%
Staff B - Task A 10% Task B 60% Task C 30%
Staff C - Task D 100%

I then need to create a report that will show the Planned time compared against the actual time. With the report I will need to be able to provide information on daily, weekly, monthly basis.

There is also a chance that resource assignment will change on a daily basis, so therefore the input from the manager needs to have flexibility built into it.

I have a few ideas, I just thought I would throw it out there and see what came back.

If I have not explained myself will enough, please let me and I can provide more detail.

Thanks

M