How to subtract previous line data in time new line insert

mistu2020

LOAN CODE EMP. CODE APPROVED LOAN AMT. MONTH YEAR EMI AMT. CUMULATIVE BALANCE
comp loan 285 20,000.00 april 2014 670 (20000-670)=19,330.00
comp loan 285 20,000.00 may 2014 670 (19,330-670)=18,660.00

I want to do this in time of new record insertion.

How to do this???

Please help

StLi

what's the exact problem? why don't you just modify the existing line?

edit: actually: a flowfield would be the way to go if you want to have the sum of the value from the subline in the related line.

MBerger

i wouldn't calculate this at time of insertion....what if you'd delete an earlier line sometime later, because of a mistake or something ? Your sum wouldn't be correct anymore.

What you could do is the opposite : make a flowfield that calculate the total amount of this and the previous lines ( SUM of LOAN AMT. for all lines with the same Loan code, emp code etc. where Date <= Date of the line. You might have to add a proper date to your table though...what you have now isn't really up to the task )