Relational table and list field problem

I need to insert a record and also insert multiple records into another table that relate to the first record.

I have created an insert page using the wizard. I then created a table relation using the Relation Table wizard. I have added a list field that is populated dynamically by a recordset and I am now trying to Insert Multiple Inserts using the list field however when I try I get the error - 'Your page must contain form elements in a repeated region to use this interface.

I thought I was using a repeat region by adding the data dynamically from a recordset.

<select name="Week[]" size="5" multiple="multiple" id="Week">
<?php
do {
?>
<option value="<?php echo $row_Week['Week']?>" <?php if (!(strcmp($row_Week['Week'], WA_AB_returnPreSelectValue($WA_PreSelect_RelationalTable_1, $row_Week['Week'])))) {echo "selected=\"selected\"";} ?> ><?php echo $row_Week['Week']?></option>
<?php
} while ($row_Week = mysql_fetch_assoc($Week));
$rows = mysql_num_rows($Week);
if($rows > 0) {
mysql_data_seek($Week, 0);
$row_Week = mysql_fetch_assoc($Week);
}
?>
</select>

While the loop for the list is like a repeat region you will need to have the form elements within a repeat selection. You can apply this by selecting just the form elements to repeat, then select Server Behaviors > DataAssist > Repeat Selection.

The multiple insert works on a group of form elements that are repeated dynamically. The server behavior makes use of these repeated fields and must have them on the page in order to function. Once you have it setup correctly you will be able to add in the multiple insert and for the bindings you will specify the repeated form field for the corresponding column.

So do I have to have multiple menu/list fields? Can't I have one and repeat the option. I have tried to do this but it doesn't insert work correctly. I inserted a record but the fields were blank.
<select name="Week" size="5" multiple="multiple" id="Week">
<?php
// RepeatSelectionCounter_1 Begin Loop
$RepeatSelectionCounter_1_IterationsRemaining = $RepeatSelectionCounter_1_Iterations;
while($RepeatSelectionCounter_1_IterationsRemaining--){
if($RepeatSelectionCounterBasedLooping_1 || $row_Week){
?><?php
do {
?>
<option value="<?php echo $row_Week['Week']?>"><?php echo $row_Week['Week']?></option>
<?php
} while ($row_Week = mysql_fetch_assoc($Week));
$rows = mysql_num_rows($Week);
if($rows > 0) {
mysql_data_seek($Week, 0);
$row_Week = mysql_fetch_assoc($Week);
}
?>
<?php
} // RepeatSelectionCounter_1 Begin Alternate Content
else{
?>
<?php } // RepeatSelectionCounter_1 End Alternate Content
if(!$RepeatSelectionCounterBasedLooping_1 && $RepeatSelectionCounter_1_IterationsRemaining != 0){
if(!$row_Week && $RepeatSelectionCounter_1_Iterations == -1){$RepeatSelectionCounter_1_IterationsRemaining = 0;}
$row_Week = mysql_fetch_assoc($Week);
}
$RepeatSelectionCounter_1++;
} // RepeatSelectionCounter_1 End Loop
?></select>

In order to use the multiple insert server behavior you will need to have multiple select lists on the page in a repeated region.

In php it is possible for you to have a single multi select list that can post an array of values, but to use it like this you would need to have a custom loop around your insert. Using the multiple insert you must have multiple form fields in the repeated region.