Recordset help

[WarDemonZ]

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

[Günter_Schenk · Accepted solution]

WarDemonZ wrote:

Is this possible?

That´s an easy one 😉

The attached screenshot shows how to replace the initial static value of your second menu query with a dynamic "connection" (e.g. $row_main['cat_id']) to the "cat_id" column of your main recordset.

[WarDemonZ]

Ah thats fantastic, i had a feeling it would be more simple than i thought, i had a first go at the advanced screen and couldnt make it do what i thought and basically panicked lol

Thanks for the help