Summarising designers time to Job book? ...

[frankH]

Hiya...

Whilst I have been using the basics of FMP for many years, I am a designer, not a programmer!

I have a little challenge - i have a timesheet entry database which records designer, job number, date and hours spent on job (Amongst other things). Each entry is a separate record.

My challenge is that I have a Job Book file, that contains details of the work in progress and I want it to display the amount of time each designer has spent on the work, on an updating basis...

So the Job book needs to sum the total hours for each designer for each job across all dates...

Any suggestions please?

I'll attach the two files in question.

many thanks

Frank

FileMaker Version: 5

Platform: Mac OS X Jaguar

timesheet.zip