Copying table records to a temporary table?

Discussion created by on Jan 13, 2012
Latest reply on Jan 13, 2012 by MikeMcErlean

I copy a found set of records to a temporary table tagged to the logged-in user's ID. The user can then select records and add data in a portal. These modified records are then used to build links in a many-to-many link table. Currently I create a found set in Table1_Layout then switch to Table1_Temp_Layout and import the records into the temp table. This works great, but the FMPro documentation indicates that this will not work in a web solution. I need to have desktop, web and FMGo access. I have done the same thing by looping on the found set and capturing the needed fields to global variables, adding records to the temp table then setting the temp table fields from the global variables. This also works fine, but seems very cumbersome. Does anyone know of a cleaner way to accomplish this? Any help would be greatly appreciated.