3 Replies Latest reply on Feb 10, 2012 3:16 PM by philmodjunk

    Manipulating Multiple Tables

    fred@kca-inc.com

      Title

      Manipulating Multiple Tables

      Post

      In several scipts in my app, I have to loop through one table then switch to a second table to add a record (link table).  Currently, I have to use 2 layouts.  This is a simplified version:

      Freeze Window

      Select Table1_Layout

      Loop

       If Field2 = 1

        Set $$Temp_Variable1 from Field1

        Select Table2_Layout

        Insert Record

        Set Field1 from $$Temp_Variable1

        Select Table1_Layout

        Goto Next Record; Exit at end

       EndIf

      End Loop

      I believe that the web version of the app does not accept the Freeze Window script step.  Is there a way to do this with a single layout or no layout?  If I create the web version, will I see the layouts switch back and forth for each iteration of the loop?

      Any ideas would be appreciated.

      Thanks

      Fred