Multiple data insert with checkbox (variation)

I am trying to get the insert page to use all the data provided before my bolt pattern checkboxes, loop through the bolt patterns adding a new record to the database, if that checkbox was selected and use just that value for that record.

The idea is to be able to insert many records to the database with on click of the insert button. All the data for the records is constant but the bolt pattern. I need only one bolt pattern per record. for instance, if I had 10 different bolt patterns and selected 4, when I click the insert button I would get 4 different records in my database and the only thing different in the records is the bolt pattern.

I hope I explained this clear enough. Attached is my insert page I am working on. Any help would be much appreciated.

Thanks,
Bknvc

Looks like you are on the right track. Now you need to apply the insert multiple records server behavior instead of the insert server behavior.

Before that you will need to add a hidden form element directly before the checkbox like:

<input name="HidField<?php echo $RepeatSelectionCounter_1; ?>" type="hidden" value="1" />

The reason why is that the multiple insert server behavior depends on at least one element from the form existing in order to do an insert and an unchecked checkbox acts as if no values are in the form at all and would break out of the loop.

Anyway... remove the insert server behavior and apply the insert multiple server behavior and see how it works for you from there.