4 Replies Latest reply: Feb 25, 2013 2:29 PM by Jaffee2 RSS

    updating a table

    Jaffee2
      Hello,
      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?
      
      
      Thanks.
      
      
      acct no           sub account n