OK I don't even know what to search for with this. I could probably do it with about 900 nested ifs but I'm betting there is a much more efficient way of doing it.
index varCode[index] varDescription[index]
0 10 cat_old_survived
1 20 cat_old_died
2 30 dog_young_playful
4 31 dog_old_dead
5 32 human_middleaged_alcoholic
Right now these are placed into 1 combo box with the following contents
10 cat_old_survived
20 cat_old_died
30 dog_young_playful
31 dog_old_dead
32 human_middleaged_alcoholic
What I need to do is create 3 context sensitive dropdown boxes
First box:
cat
dog
human
If user selects dog then second box has:
young
old
If they select old third box just has:
dead
Now for the fun part. After user has selected all 3 options it needs to associate it back to the corresponding code. In the above example:
Combo1 = dog
Combo2 = old
Combo3 = dead
would equal
varDescription = dog_old_dead
varCode = 31
Does this make any sense to anyone but me? If so any suggestions?
index varCode[index] varDescription[index]
0 10 cat_old_survived
1 20 cat_old_died
2 30 dog_young_playful
4 31 dog_old_dead
5 32 human_middleaged_alcoholic
Right now these are placed into 1 combo box with the following contents
10 cat_old_survived
20 cat_old_died
30 dog_young_playful
31 dog_old_dead
32 human_middleaged_alcoholic
What I need to do is create 3 context sensitive dropdown boxes
First box:
cat
dog
human
If user selects dog then second box has:
young
old
If they select old third box just has:
dead
Now for the fun part. After user has selected all 3 options it needs to associate it back to the corresponding code. In the above example:
Combo1 = dog
Combo2 = old
Combo3 = dead
would equal
varDescription = dog_old_dead
varCode = 31
Does this make any sense to anyone but me? If so any suggestions?