2 dimensional arrays and combo boxes

[heygmiller]

I have 2, 2 dimensional arrays. One called project, one called scenario. Each of these 2 dimensional arrays has a description column and a mnemonic (unique identifier) column.

for example,

project(0,0) = Oil Price Shock project(0,1) = obj(0).title
scenario(0,0) = US Baseline Forecast scenario(0,1) = obj(0).scenarios(0).title

I'd like to have 2 dropdowns. One to select my project, and a second to select one of the scenarios that is available through the project selected. My hope is to be able to map the scenarios to the correct project based upon the mnemonic column in my arrays.

Any idea as to how I'd go about doing this? Been googling for hours with no luck. I'm stuck.

Appreciate any guidance and wisdom. Cheers.

 

[bobsan42]

you will need at least one more column (Project) in your second array - to be able to filter when a project is selected