I was already created Form for CardTopUp by using CardTopUp Table. It has These fields.
CardNo
Amount
There is another table CardDetails It has these fields.
CardNo
Balance
In this field there is a amount .
What i want to do it when iTop up my card using CardTopUp form, when click submit button
1.Record that data to the CardTopUp table. (It's ok its working also now)
2.I want to update CardDetails Table Balance Field. Add topup amount to CardDetails balance field.
As a example in balance field abailable 1000 and i am topup 200 i want to see in carddetail table 1200
How to do?
CardNo
Amount
There is another table CardDetails It has these fields.
CardNo
Balance
In this field there is a amount .
What i want to do it when iTop up my card using CardTopUp form, when click submit button
1.Record that data to the CardTopUp table. (It's ok its working also now)
2.I want to update CardDetails Table Balance Field. Add topup amount to CardDetails balance field.
As a example in balance field abailable 1000 and i am topup 200 i want to see in carddetail table 1200
How to do?