4 Replies Latest reply on Feb 25, 2013 8:29 PM by Jaffee2

    updating a table

      I have a table with account no and sub account no 
      The table looks like below:
      *account no    sub account no     fields a              fields b           fields c*
      1010                  00                      x                     y                  z
      1010                  10                      x                     y                  z
      On the form the user can update 1010 / 00 for 1 row on the form
      and also update 1010/ 10 on another row.
      I wish to update account no 1010 in either scenario, whichever row they choice. I need to keep field a, field b and field b the same for account no ,but differenct sub account no.
      What trigger do I use?
      acct no           sub account n