2 Replies Latest reply on Sep 24, 2009 6:18 PM by TLC-IT

    Can cfselect do it?

    ws1267

      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:

      idGenderAgeLocationDate
      1F25x1/2/09
      2M20y.
      3F35y.
      4F42x.
      5M20z.
      6M20x.

      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.