Insert unique id in repeat section

Hi Ray,

I am trying get a mysqli repeat section to insert the unique id but it is only inserting the first id in the results. I have the page attached. What am I missing?

thx
Eric

I'm not sure exactly what you are trying to do and where it is failing.

Are you submitting the first form or the second form? Which column has the wrong value after the insert? What value does it have and what value would you expect it to have?

It should insert from either form. One is the winner, the second is the guest of the winner. It should be pulling the actID from the rsSchedule records and inserting that into the OrdersDetail table. It is only inserting the first record in the recordset instead of the actual record you select.

See PM

see pm

Each row has the same actID and you are filtering based on the actID for the recordset that controls the insert.

You would want to pass the id and filter a recordset with the id column in order to insert the correct row. It looks like you have that value in a hidden form element named "id", but you never use it to filter the recordset.

One of the problems is that you are inserting from the same recordset you are using to display. That can be tricky because you are displaying multiple rows and inserting just one.

I'd start by creating a new rsInsert recordset that you filter with the hidden id and the actID that is passed in the url and then use that recordset for the insert. It would only return one row, and it would be the right one that you want inserted.

Got it! Thanks Ray!!