Portal Totals Help

[scottvaughan]

I have a portal that show me records from my main DB. We are a printing company and I use it to show me all of the jobs that are printing on a certain kind of paper. So in my header, I choose a paper type and the portal displays all records which match. Each record in the portal also shows me how many sheets I need. I want to find a way to total all of thos sheets via the portal. Is this possible?

[bcooney]

Create a calculation in the main DB table = sum(portalrelationship::qty_sheets). It must use the same table occurrence that the portal uses.

[mr_vodka]

Create a summary field in the child table then put that summary field on the layout of the parent table occurrence.

[scottvaughan]

Great, Thanks for the help. It works now.