Calcs over relation

[dnowlan]

I have received help on this but still no go. I will try better to explain the issue:

I have 2 databases:

Database 1 has a summary page to pull data from the database 1 and other related databases. Database 2 has temp employee data

I want to be able to show, in the summary page in database 1, the total dollars spent on the current found project from the temp database.

In database 2 I calculate the "record total" in database 2 and basically need to have a field in database 1 that says something like: case(project=databse2::project, sum(linetotal))

When I do this the field is blank.

Help!!

Thanks!!

[LiveOak]

Lose the case statement. Relate the files by project number and use the sum function:

TotalFromDB2 (calculation, number) =

Sum(DB2byProjectNum::linetotal)

I'm assuming that each record in DB 1 represents a project (as you wanted to test on it using case).

-bd