live updating inventory

[schmegol]

I'm not bad at FMP, but I created an invoice table that has "items" field that is related to a "items" field in a table called "Line items" that is related to the field "items" in an Inventory table.

My question is how when I create records in my invoice portal showing "line items" to update my inventory as each line is created. There are some summary calculations missing here. I have something sort of working but the inventory does not update instantly with each portal record being created or deleted.

[Søren Dyhr]

Use the aggregate function instead of the summary!

--sd