Checkbox list returning only one result from Managed Relational Table

My update page checkbox list and corresponding labels will only show the correct item related to the product. I need it to show the other, unchecked items as well. I've added the repeat selection server behavior (per the MRT tutorial) in different ways, always with the same result. Also tried using different recordsets for the checkbox and label, but same result.

I can get it to show the full list, or the correct checked item from the list, but never both.

I don't know your database structure, so it is hard to determine what exactly needs to be updated.

I think you need to get back to the point where it shows the full list. That is what you need. Then we can work on getting the correct items selected in that list next. It is probably going to take two separate recordsets to pull off. The issue probably is that you are using one recordset for both and that is always only working for one piece or the other.

After reviewing the Manage Relational Tables tutorial, its purpose is only to show how to insert or update multiple items (like from a checkbox list), not how to have the checkboxes checked relative to each product, like I thought. Will still be using the MRT in several instances, but also need help on the checkbox issue.

My list is now showing all results. I've also added another recordset just for the checkbox, but it won't show the proper item as checked. Will either show all checked or none checked.

The manage relational table automatically creates an array to help you pre-select. So you can remove the recordset you have created for that purpose.

The array name is:
$WA_PreSelect_RelationalTable_1

and you can see it is created on lines 276-296

To use that array to do the selections you can add this code to your checkboxes:

<input type="checkbox" value="<?php echo $row_prod['ProdIDType']; ?>" <?php echo(in_array($row_prod['ProdIDType'],$WA_PreSelect_RelationalTable_1)?"checked":""); ?>>

After updating the source code, still getting complete list, but no checks.

New file attached.

You have slanted quotes a few places that could be causing issues:

$_GET[’ID’]

should be:
$_GET['ID']

I don't know if the slanted quotes will post on the forum, but you can see them in your source code on lines 224 and 273.

If that doesn't work, could you give me FTP access and a URL to view the page? I could debug it quickly that way.

Slanted quotes have been replaced with same result.

See PM

You had your checkbox values set to the wrong recordset and column. I've updated it and it appears to work correctly now.