Use the simple view to create the recordset and use the select lists provided to filter the ProductID column with the URL Parameter id.
That will automatically write the query you want to use without breaking the dreamweaver recordset so that it will still work with the add to cart interface.
Cool. Learn something new each day.
Quick question: How do I make the UPS Shipping offer multiple options when the original wizard is only allowing a single shipping method?