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>