Summary from one table to another

[Heathbo]

How do I take the value from a summary in table 1, and show it in table 2? Portals don't work, creating a field that links to the summary doesn't work.

[Vaughan]

Are you using a calculated summary field (using GetSummary)?

[Heathbo]

No, I am using a summary field, not a calculation field.

[transpower]

Just take the summary field from table 1 and place in on a layout for table 2. If the two tables are properly linked (check your Relationships Graph) you will see the appropriate summary displayed.

[Heathbo]

My problem is in the relationship graph my summary fields are greyed out. I also already have a join file in between table 1 and 2.

[LiveOak]

Summary fields are context sensitive in the sense that the value they return is dependent upon the found set for summmary fields in a trailing grand summary part and upon found set and sort order in a subsummary part. I'd try defining a calculation field using the GetSummary() function and using this field in the related table. As an alternative, you can define a calculation field using the Sum(relationship::field) function in the related table. The relationship will determine the set of records aggregated.

-bd