I have two tables.
1. CardDetails
Fields: CardNo
Balance
2.CardTopUp
Fields : CardNo
Amount
I created a form using CardTopUp Table. What i Want to do is when i click submit button
1. Insert the record to Cardtopup table
2.Update only Balance field on CardDetail according to CardNo. (I want to add Cardtopup Amount to the remaing Balance on Card Details table.
As a example is there is 100 balance and when i topup 200 i want to update balace field as 300.
Please tell me how to do that
I
1. CardDetails
Fields: CardNo
Balance
2.CardTopUp
Fields : CardNo
Amount
I created a form using CardTopUp Table. What i Want to do is when i click submit button
1. Insert the record to Cardtopup table
2.Update only Balance field on CardDetail according to CardNo. (I want to add Cardtopup Amount to the remaing Balance on Card Details table.
As a example is there is 100 balance and when i topup 200 i want to update balace field as 300.
Please tell me how to do that
I