I guess that I'm having a hard time understanding what part you are stuck on in regards to the recordset. Do you want to list all of the available options from your options table? If so then your recordset should just be a simple 'SELECT * FROM your_product_table'.
If you want to display only certain options from this table to associate with a product then you would want to further filter the recordset to only include these options.
The idea is that this recordset will power the list of available options that have check boxes next to them. You will use the checkboxes to associate options for the product you are working with, it is the MRT server behavior that will handle the association in the db for you, this first step is just to get the options listed on the page for you to associate with the selected product.
If I'm misunderstanding the question or issue at hand please explain for me. I apologize if my last post came off as disrespectful in any way, that was not my intent, I deal with an assortment of user experience levels every day.