Skip to Content
0
Nov 06, 2012 at 05:37 PM

populating list of values for a combo box based on selection of another combo box

88 Views

Hello experts ,

i have a requirement .. I need to populate the values for a combo box based on selection of another combo box

I got two combo boxes one for REGION and another for COMPANY

The combinations for the two are below . .

REGION --- COMPANY

ALL-----ALL

R1-------ALL

R1 ---- C1

R1-------C2

R1-------C3

R1--------C4

R2--------ALL

R2--------A1

R2---------A2

R2---------A3

R3- --------ALL

R3---------B1

R3---------B2

R3---------B3

I was able to retrieve and populate the values of AREAS based on selection of REGIONS. but i need to include the records ALL using some exccel logic in dashboard.

so my question is how do i preselect ALL area combo box whenever i make changes with REGION .

In other words every time i change the region eg from R1 to R2 or from R3 to ALL or R2 to R3 . . the defualt selection on AREA COMBO box should be ALL

Any suggestions would be appreciated ?

the way i am getting the results is bit different from what required .. whenever there i s a change in REGION i am hitting the query and populating the list of values for AREA . and I even tried to bind ALL to item cell for COMBO box AREA .. but no luck with it ..either i may be designing it wrong ... let me know if you guys have any ideas