Hi,
If I wanted to populate a dropdown list in a itemtype like this:
Region 1
- Under region 1 - 1
- Under region 1 - 2
- Under region 1 - 3
Region 2
- Under region 2 - 1
- Under region 2 - 2
- Under region 2 - 3
Would that be possible via SQL method?
And/ OR:
If thats not pissble. Any ways of creating a chained-it dropdown. By that I mean:
Dropdown 1:
Region 1
Region 2
Dropdown 2 (if Region 1 is picked) will have these:
Under region 1 - 1
Under region 1 - 2
Under region 1 - 3
Any ideas how to get this done would be appreciated. If not possible - then just say that too:)
regards