Balance Accumulator

[nub_the_doob]

I have a 3 columns. 1) Beginning Balance 2) Payment 3) Balance.

I want my form to accumulate the each payment. For instance:

Beginning balance is $500. The customer makes a $100 Payment. A form is used to update the payment column to $100. The balance updates to $400.

When the customer makes the next payment of $100, I want the user to enter $100 into the form and have the app accumulate that payment column to $200. What

[lynchk21 · Accepted solution]

You either need to:

1. Have payments as a child table and then sum all related child payment entries related to the parent balance
2. Have another column, call is [Total Payments] and then have an action or bot that sums [Total Payments] and [Payment] each time the [Payment] column in the row is updated: [_thisRow_Before].[Payment]<>[_thisRow_Before].[Payment]