append record whith do while function
Hi
I have create two table one tblIBB with fields name, ob(loan),
lsdt(loan sanction date),lrdt(loan recovery date),aoi(amount of installment),
cb(closing balance) another table IbbMst with above same fields
Now my problems is in my form one append button is there when I click
the append button I want append the record in table tblIBB in to IBBMst
with do while tblIBB.aoi>0
I want replace ob with cb
and if lrdt<lsdt
replace cb with ob-aoi
replace date with lsdt
for eg.
tblIBB
ob lsdt lrdt aoi cb
1000 01/01/07 01/02/07 100 0
Now I want append the records in table in IBBMst like below
Ob date(lrsdt) aoi cb
1000 01/02/07 100 900
900 01/03/07 100 800
800 01/04/07 100 700
700 01/05/07 100 600
600 01/06/07 100 500
500 01/07/07 100 400
400 01/08/07 100 300
300 01/09/07 100 200
200 01/10/07 100 100
100 01/11/07 100 0
In above meathead how should the code in click event
|