Summary Fields -can I reference via a relationship

[Steven Cappiello]

How can I reference a summary field / can i reference a summary field

via a relationship

in file 1:

lab id

expense

summary of expenses for lab

in file 2

i'd like per lab record to show the summary field from file 1

is this possible either via relationship or calculation ???

[-Queue-]

Create a relationship from file2::lab id to file1::lab id and a calculated number field of Sum(file1::expense).

Summary fields are local and dependent on found set. This is why you need a calculated field in the other file.