Solved
Totaling Child Records Live on Parent Form
I have created a parent table called "time reports" and a child table called "time spend on projects." On the "Time Reports" form, the user is able to enter the percent of their time they worked on ...
The problem is that when you refresh the record, if the only changes are to the children in Grid Edit, then the parent record has not been "dirtied", and it will hence not Auto Save, when navigating away to refresh the record.
So, np, what I do is to make two fields and out them in the form in a hidden section. The first is called [Dummy] as a numeric field and the second is a formula numeric [Dummy +1] with the formula of. [Dummy + 1]
then a formula rule that says when [Dummy] is not equal to the value in the field [Dummy +1] change [Dummy] to the value in [Dummy+1].That will dirty the record as soon as the parent is put in Edit mode and hence it will Auto Save when you navigate away.
