Timesheet Relationships

[paperbag1]

I am trying to make a timesheet to track time per task. Currently, I have 5 records 1 each for Mon-Fri. for Bob all within the same week. I have made a layout that displays the records in a table view like below.

Nme M TU W TH F

Bob 8 0 0 0 0

Bob 0 8 0 0 0

Bob 0 0 8 0 0

Bob 0 0 0 8 0

Bob 0 0 0 0 8

I would like to have the layout display like the following.

Nme M TU W TH F

Bob 8 8 8 8 8

I am unable to come up with a solution to do this. I have used Filemaker for a few years but am not very strong in developing. This will eventually have many records of many people in the DB which will key off of a Week Ending Date. I am unsure how to set up the proper relationships to achieve my goal.

* The formatting is off a bit in this post but hopefully you can understand the layout.

I have attached what I have so far for a better understanding of what I'm trying to do.

Tracking_Timesheet.zip

Edited March 26, 2010 by Guest
Included file.