2 Replies Latest reply on Dec 28, 2012 11:44 AM by BKBK

    second dropdown based on previous dropdown?

    sakonnetweb Level 1



      There seems to be no easy way to accomplish this without javascript/CF  with dozens of lines of code.


      The scenario: table 1 has banks, table 2 has loan processors. Client chooses bank from DDSB, only the processors from that choice show up in the second.


      Processor table has FK relationship to bank PK.


      ColdFusion 9.0.1,
      Microsoft SQL Server 2008 R2


      Is there a simpler solution?


      Thanks and have a great New Year.