Hi I have a form with the following fields i need some help.
CustomerName PurchaseItem UnitPrice Quantity Balance OldBalance TotalBalance PaidBalance RemainingBalance
xyz--------------- Pen----------- 5---------2------- 10------- 0---------- 10------------ 5--------------- 5
abc--------------- Pen----------- 5-------- 3------- 15------- 0---------- 15------------ 8--------------- 7
xyz--------------- Book---------- 10------- 1-------- 10------ 5 ---------15----------- 15-------------- 0
abc--------------- Ink------------ 2-------- 3-------- 6------- 7 ---------13----------- 13-------------- 0
I need to bring the RemainingBalance "5" of the customer "xyz" into the OldBalance in his next record. Help me Brothers.