Update Record and Update Multiple Records together

Hi, I have a single form that the user fills out, but there are also repeat regions within that form... ie:
Name: User
Address: On a Street
***** Repeat Region *****
Friends with:
Stephen
Joe
Peter
***** End Repeat Region *****
Contact Number: 12345678

Submit

Is it possible to have this update all within one form and submit button, and if so, how?

Thanks

Yes, that can be done.

add the Multiple record update behavior t your page, just make sure that the regular update behavior does not redirect to another page so that the multi update behavior can trigger.

I'll give it a go... I had tried that before and it didn't work... but I've just updated my behaviours, so will try again... hopefully it works this time :)

Hi, I tried this again and it's not working. It will work with the single update behaviour, although the page does need refreshed to display the update.

the multip update uses the WADA_RepeatID_garage_fitter_id looped hidden element to determine which records should get updated:

<input type="hidden" name="WADA_RepeatID_garage_fitter_id_<?php echo $RepeatSelectionCounter_1; ?>" id="WADA_RepeatID_garage_fitter_id_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo $row_fitter["garage_fitter_id"]; ?>" />

the value for that element uses the garage_fitter_id column of the fitter recordset:

value="<?php echo $row_fitter["garage_fitter_id"]; ?>"

the select statement for the recordset:

SELECT garage_id, garage_fitter, garage_fitter_parts, garage_fitter_comments, user_first, user_last FROM....

does not include the garage_fitter_id column. this cause the hidden element to be blank, so it cannot pass the ID for the record to update. edit the recordset to include the garage_fitter_id column in the select statement.

as for the page needing to be refreshed, this is due to code order.


the recordset that populates the page comes before the update record code. this means the recordset is created, then the database is updated so it shows the old content. rearrange the code so the update happens before the recordsets are created, this will allow yo to see the update without having to refresh.

Thank you... it's always something really simple that tiredness makes you miss. This worked a treat.

Cheers