This discussion is archived
6 Replies Latest reply: Nov 12, 2012 11:14 PM by Moazam Shareef RSS

forms 6i update balance of stock control

yasser_egypt Newbie
Currently Being Moderated
dear people
i have table for stock control and i want the balance updated every row
for example
i have table inside for with the following database items
balance 100
add 50
total 150
i want that this balance update with every transaction for every row
for example second row should be
balance 150
add 20
total 170

third row should be

balance 170
add 30
total 200
and so on
pls help me

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points