YEeah, so like i said, there is already the WADAproduct recordset on this page. and that recordset is already set to filter the product.ProductID on the URL variable that is passed in.
instead of creating a second recordset, just edit the existing one to add your join.
in the server behaviors panel, double click the WADAproduct recordset to edit it, In Advanced mode, change it from:
SELECT * FROM product WHERE ProductID = colname
to:
SELECT product.*, quality.QualityName FROM product INNER JOIN quality ON product.QualityID=quality.QualityID WHERE ProductID = colname
Notice that colname used in the WHERE is a variable defined as:
Name: colname
TYPE: Integer
Default Value: -1
Runtime value: $_GET['ProductID']
the $_GET['ProductID'] URL variable tells the details page which product to load
