November 14, 200421 yr 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.
November 15, 200421 yr 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.
November 16, 200421 yr Author 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.
November 16, 200421 yr 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
Create an account or sign in to comment