ASP Options on Category page

I have a site where some, but not all products have options.
The options vary by product.
There is no price associated with the options. They are things such as size or colour.

I have a working Category page, on which I have a Buy now button leading to a Product Details page. On the Product Details Page, I am able to call up the options by linking the tables in the RecordSet. Adding to cart at this level is no problem. Everything works fine.

What I would like to achieve, is to eliminate the Product Details page but I cannot get the options to display properly on the Category Page.

I can envision the resolution, but I cannot code it.

What I need is a second recordset for options that would look something like this.

rsOptions

SELECT *
FROM options
WHERE prodname = param

param = prodname from rsProds

I've tried doing it with a hidden form and field but that failed and I've tried calling the rsProds.prodname field directly but I cannot get the syntax to work.

If I could get rsOptions to work, the rest of it is easy. I can show or hide the options dropdown based on whether there is a value in rsOptions.

Can this be done?