Managing Relational Database - update page problem

Hi Ray, I've added a new relational table to a database and consequently need to update the insert and update record pages. I've managed to do the insert page using new checkboxes populated from a recordset and an "Insert Multiple Records" behavior which writes the values to one of the new tables. All works fine. However, the update existing record page has got me stumped!

I've added the same checkboxes to the update page, populated via a recordset, and then used the Manage Relational Table behavior to write the primary ID from the record, along with the values from the selected checkboxes, to the new table. It's only writing the first checkbox value though, so how do I get it to add multiple checkbox values? Do I need to combine the Manage Relational Database with Update Multiple Records? I've attached a copy of the update page for reference, along with the insert page which writes everything correctly.

Try renaming your checkbox to Filter[]. Without the square brackets, only one value will be submitted.

That fixed it, thanks! The only other thing I need to do is prepopulate the checkboxes on the update page if there are already values saved for that LenderID. At the moment the repeating checkbox value is <?php echo($rsFilters->getColumnVal("FilterID")); ?> how would I change this so that it will prepopulate if a value already exists, but will also pass a new value if it doesn't already exist?

I had a fiddle with it to see if I could work it out - and I did!

I added a recordset to get all entries in the relational table with that LenderID:

<?php
$rsCategories = new WA_MySQLi_RS("rsCategories",$Exclusives_i,1);
$rsCategories->setQuery("SELECT * FROM LenderCategories WHERE LenderCategories.LenderID = ?");
$rsCategories->bindParam("i", "".$_GET["LenderID"] ."", "-1"); //paramLender
$rsCategories->execute();
?>

then coded the checkbox like this:

<input type="checkbox" id="Filter" name="Filter[]" value="<?php echo($rsFilters->getColumnVal("FilterID")); ?>" <?php
$wa_startindex = 0;
while(!$rsCategories->atEnd()) {
$wa_startindex = $rsCategories->Index;
?><?php if ($rsCategories->getColumnVal("FilterID") == $rsFilters->getColumnVal("FilterID")) { // Show if ?>
checked <?php } // Show if ?><?php
$rsCategories->moveNext();
}
$rsCategories->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?> />

Sorted!

Nicely done. Thanks for the update