I'm kind of struggling with the sequence on how to do this. Could you give me your advice at a high level?
Here's what I'm trying to do:
I have populated a temporary table with user ticket information (name, email address etc). The key to the table is the user's session id. The user enters this data on a form that comes up directly before the checkout page.
On the checkout_success page the system copies the tickets_temp table records to the ticketdetails table inserting the orderid received on the checkout_success page.
I have most of the above working, but the insert many behaviour won't work unless I put the tickets_temp table data into a repeat selection form. I don't want the user to have to click and submit a form - I just want those records to automatically be inserted on reaching the page. I intend on setting up a delete records behaviour to clear out the tickets_temp table at the end.
Should I use the insert many behaviour or is there another way to do this?
Many thanks - again.