I am working on building a small competition tracking app for our company. I am using MSFT SQL 2000 and Dreamweaver 8.

SQL has two tables.

<b>PRODUCT</b>
<i>PK_PRODUCTID
PRODUCT_NAME
</i>

<b>PRODUCT_COMP</b>
<i>PK_PRODUCT_COMPID
CFK_PRODUCTID
SFK_PRODUCTID
</i>


In my head I am envisioning two pages for this piece of the app. On the first page will be a list of our products with a Go to Detail Link attached to them, so when you click on them it will pass the ID to the next page.

The next page will have two columns. On the left is the name of the product selected on the previous page and on the right is column with dynamic checkboxes with all the products in the database.

My goal is to have the user tick of the checkboxes of the products that compete with the product they chose and hit submit and it will update the PRODUCT_COMP table.

I am having problems trying to build the recordset to make this work. Am I way off base on this? Does anyone see some alternatives?