relationship sum??

[dnowlan]

I am trying to create a summary sheet with summaries, summing total work hours on a project, in one database pulling information from others. This should be simple but I am missing something.

Database 1: Field <Grand Total work hours>

Field <Project>

Database 2: Field <work hours>

Field <Project>

Dtabase 1: Field definition of <Grand Total Work hours>: Case(database 1/field <project>=database 2/field <project>, Sum(<workhours>)

I have tried summaries and other ways but no go..

Any thoughts??

Thanks!!!

[Fitch]

The missing piece to the puzzle is that the WorkHoursCalc needs to happen in the related file:

Case(database 1::project = project, workhours)

NOW you can define a field in database 1:

Sum (database 2::WorkHoursCalc)

PS: Enclosing field names in greater-than or less-than symbols (i.e. HTML-style brackets) is likely to confuse those of us not yet fully caffeinated. Thanks.