AnsweredAssumed Answered

Manipulating Multiple Tables

Question asked by fred@kca-inc.com on Feb 10, 2012
Latest reply on Feb 10, 2012 by philmodjunk

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

Outcomes