Add a Running Total as a field in a table.
We have a Parent-child relationship. One of the fields in each child record has an amount. We want to include a running total of the amount in each subsequent record where the total has only the previ...
Forum Discussion
If they are not in Record ID# order, then what is the definition of the order sequence?
The other approach which can work on a going forward basis is to do a summary total of all children for a given parent and then do a lookup down to the children.
But then make a snapshot field to freeze that value. Then ensure that users are not allowed to delete or edit the previous records as a frozen snapshot is frozen. But that is probably too restrictive.
The other solution is to find a way to use a summary report to get close enough to what you need. A summary report has the feature to present a running total. if you contrive the summary report to group by say record ID# or date created, then each summary row will really just be one child record.
Mark
The other approach which can work on a going forward basis is to do a summary total of all children for a given parent and then do a lookup down to the children.
But then make a snapshot field to freeze that value. Then ensure that users are not allowed to delete or edit the previous records as a frozen snapshot is frozen. But that is probably too restrictive.
The other solution is to find a way to use a summary report to get close enough to what you need. A summary report has the feature to present a running total. if you contrive the summary report to group by say record ID# or date created, then each summary row will really just be one child record.
Mark