Totals from multiple files
I have a parent table which has 5 "child" tables linked to it. I have a screen which has 5 tabs which display the related records in 5 separate portals. Each portal has a total of the displayed record amounts which i display at the top of each tab. Call each of these totals A,B,C,D and E. What I need to do is also show the "grand total" of all "tab" totals. ( A + B + C + D + E )
Is there a way to do that. It would be adding up the totals from each portal totals.