How to SUM all amounts on child table?
I have a portal where I relate a customer table to orders.
I want to be able to show on the customer layout (where you see related orders on the portal below) the total of ALL orders in the orders table.
What's happening, however, regardless of how I try this (calculation, summary, etc.) is that on the customer form, my "total" only shows the total for the current customer, NOT for all customers.
I tried creating a separate table occurrence, but I get the error then (on the customer layout) that this table isn't related to the current layout (or words to that effect).
So, how do I tell FMP that I want the total of all orders, not just the ones for the currently displaying customer?
Do I need a completely separate layout or something like that?
Thanks in advance.