Sorry, I must have read your initial post to quickly and did not get the fact that you where intentionaly using the ProductCategory.
ok, so going back to the original post, you had the SQL as:
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName = 'Metal' AND productoptions.ProductCategory = paramItem
With ParamItem default value: -1, runtime value: $row_WADAproducts['ProductCategory']
your on the right track with this, but there are a couple problems in the code you posted in message 8:
that will prevent this from working.
1) the products recordset on this page is not named "WADAproducts", it is named "products". the runtime value for ParamItem should be:
2) Code order. the rsMetal recordset is before the products recordset. To be able to use the value of the products recordset in the rs metal recordset, you will need to rearrange the code so that the products recordset is before the rsMetal recordset.