Recordset help

Hi everyone

I hope this is in the correct forum

Iv been trying to work on a dynamic ecommerce site recently, and think I have it pretty much all correct and accounted for im just struggling when it comes to a certain aspect of creating an option set for my product catalogue. Im trying to make an option dropdown from a recordset but im trying to make the recordset alter based on different records in my data.

In my 'option' table i have a unique ID, optionID and option value such as

1     1     Red

2     1     Blue

3     1     Green

4     2     Black

5     2     White

6     3     Orange

7     3     Yellow

However i want the recordset to filter based on a value in my 'product' table, There is the option to filter these results but it only allows me to enter in a static value, I assume i would need to use the advanced option to make this work correctly, effectively what i want is to only show the options which correlate with my product 'optionID' field. So if record 1 had optionID 2 the options would only show Black/White etc

Is this possible?

Many thanks

Andrew