I apologize for my english.
I was googling but couldn’t find an answer to my problem.
I have a header table, with columns of calculated totals that add up to amounts from a child table.
-TotalOrder = SUM (SELECT (SalesLines [Subtotal], [SalesNo] = [_THISROW]. [SalesNo]))
Obviously, first I create a record in the header table which is written to my excel file. But when I enter a new line in the child table, I can’t get the calculated field “TotalOrder” to be refreshed. I have to open the form in edit mode for the header table and save to refresh the “TotalOrder” field. .
I tried to create an action for records in the header table, Data: set the values of some columns in this row, but it only shows me the fields that do NOT have a FORMULA.
Am I misusing the summation in the header?
Is there a way to trigger in another table an update of its fields with formula?