Hi all
I have built a form for new orders, it includes the ‘orders’ table which has customer information, and ‘order details’ table which has product information with the order number being the ref between them.
after saving the product details in the form I would like the initial price of ‘order’ table in the form to be the summary of the price in the details. I added initial formula, but it does not seem to work. Any ideas?
Solved! Go to Solution.
I tested, in one of my long standing apps, moving the SUM expression from App Formula into Initial Value. The expression will NOT re-fire upon return from the child form.
So, for now at least, you MUST place your expression into the App Formula property for the parent Form to properly sum the child records in a new parent Form.
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |