Hi guys
I have a table called "main" contains five fields "account", "x" , "y" , "netaccount" ,and "notes"
the field "netaccount" is a calculated field where netaccount=account-x+y
when I add a new record account field automatically takes the value of netaccount of the previous record
THE PROBLEM is when I delete any record I need a code that recalculate the account and solve the gap that occurred due to deleting the record
this image might help you to understand the problem when you try to delete any record