i have table for stock control and i want the balance updated every row
i have table inside for with the following database items
i want that this balance update with every transaction for every row
for example second row should be
third row should be
and so on
pls help me
I still don't understand what should exactly happen. There is some event, and then? Is a new record inserted in your table? Or have some of the rows to be updated? And what is your sort-criteria? Do you have some date-column or some transaction-id?