Can cfselect do it?
I use cfselect as chain-react select boxes, it work perfectly. But I have an instance I have to set BindOnload = true to all dropdowns, so user is able to start from any dropdowns, I tried but not much success to get it to work. The reason, it may not work in a chain-react manner, it has to be custmomized to cover every conditions.
For example, if the select boxes are Gender, Age, Location and Gender, Age, Location are columns from the same database table by selecting distinct record. The data may look like this:
| id | Gender | Age | Location | Date |
|---|---|---|---|---|
| 1 | F | 25 | x | 1/2/09 |
| 2 | M | 20 | y | . |
| 3 | F | 35 | y | . |
| 4 | F | 42 | x | . |
| 5 | M | 20 | z | . |
| 6 | M | 20 | x | . |
Gender dropdown should look like:
ALL
F
M
Age dropdown:
ALL
20
25
35
42
Location dropdown:
ALL
x
y
z
How do I set the dropdowns so user could start from any dropdowns and repopulate the rest two?
If user starts from Location and select z then
Age should select 20
Gender should select M
if user start from Age and select 20 then
Gender should be polulated
ALL
F
M
Location should be populated
ALL
x
y
z
Is this doable with or not with cfselect?
Thanks.
