3 Replies Latest reply on Apr 19, 2009 1:37 AM by raybaudi

    Return to table row

    synergy46

      Title

      Return to table row

      Post

      There is a layout name Members.  On this layout is a portal.  The portal references Accounts.

      Accounts:

         AccountNUM:  (text)

         Description:    (text)

        etc..

       

      These two fields are in a portal.  I have setup a script trigger that executes on AccountNum Save.  The ST goes to an Accounts layout and does a Find in the AccountNum field.   If it finds the AccountNum it sets a variable to the value of the Description.

       

      I need a way 'capture' the table row when the ST fires, perform the find (it finds the first occurance), copy the Description of the found record to a variable and then go back to the 'set' row and insert the description.

       

      The basic problem is I can't find any way to dynamically name an object or row.  I know FM allows for a Goto Record By 'calculation' but I don't see any way to capture the current table row and then go to that row when finished.   FM seems short in allowing this kind of thing.

       

      Your thoughts are appreciated.