I have 2 tables.
one table is customers.
it has 3 fields. acc_number , name , sum
second table is transactions
it has transaction_id, transaction_amount, acc_number
and i have form which have all fields included.
How can i update customers.sum field when i add new transaction on form.
acc_number name sum
1001 Sven 1000
i do one transaction with amount of 500
i want to update field sum to 1500
Thank you for answer