4 Replies Latest reply on Oct 30, 2006 11:31 AM by dave.cozens

    Populating Related Select Fields

    BattleManJ
      I work for a university and I am working on making some reports in Coldfusion. One report is to see who was participating in an extracirricular activity during a certain semester. I would like to have it so my first drop down is populated by querying all the activities in the database and then once the activity is chosen the 2nd drop down will be populated by querying all the semesters that activity took place (i.e. football doesnt take place during the spring or summer semesters so my user doesnt need to be allowed to choose those semesters). Is there a way to populate the second field based on the first field without hardcoding this in JS or without using AJAX?