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