6 Replies Latest reply: Nov 13, 2012 1:14 AM by Moazam Shareef RSS

    forms 6i update balance of stock control

      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