3 selects - can 3rd be based on 1 AND 2?

[sam308940]

I have 3 menus. I have gotten select1 to update select2. However I need select3 to update based on select1 AND select2 options. I have searched around and I just want to know if this is possible - or if its a dead end (ie dont waste my time going down this road).

heres an example of what i need to do.
we have paint, indoor OR outdoor (select1)
we then have shine: flat, semi gloss, gloss (select2)
we then have color: blue, red, green (select3)

the color needs to be populated based on select1 and select2
ie only colors that are indoor AND flat.

does this make sense?
anyways to get DD to do this?

[Dave Buchholz]

Yes is the simple answer.

I have an example here (http://www.i-cre8.co.uk/webassist/multiple-dynamic-dropdowns/index.php) where the 3rd dropdown (Engine Size) is generated by the selections made in the 1st two dropdowns (Manufacturer & Model).

[sam308940]

i copied your files to my server
but it doesnt work for me
i get no errors.....
the select1 populates, but on selection there is nothing populating select 2 or 3.
those remain empty.

[sam308940]

D-uhhhh
Read instructions!!
i thought it was ready to go, but i see i had to do a little work - as per the instructions!!!

ok so it works.

but i dont get it.
i only have 2 tables, your example has 4 database tables.
so this doesnt make sense to me.
ill did through this some more........

[Dave Buchholz]

Yes because there is a linking table from the models to the engine sizes

For three drop downs I would normally expect to see at least three database tables else what are you going to populate the 3rd drop down's data with ?