I have a table with 3 fields, "Resource No." (PK), "Work Center No." (PK), "Time Split %" (Decimal).
I have a list page to display these fields, I have also updated the page to a Worksheet in order to try & solve this issue.
Really I am wanting to keep track of the Total "Time Split %". (So the sum of all "Time Split %" for that Resource).
This is to ensure it always adds up to 100%.
I would like to copy the functionality on the General Journal page, which keeps track of Balance & Total Balance.
I have a function in the page, called OnAfterGetCurrRecord called CalcTotal.
The function works when the page loads, and works when a value is updated...but only if the user uses the arrow keys
to go down/up on to another record.
In the General Journal, if you change the Amount field, and just use the left/right arrow key to move off the field to the right, it updates the Balance.
Is there anything I am missing?
Attached is a screenshot of the page etc.