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.
Microsoft SQL Server 2008 R2
Is there a simpler solution?
Thanks and have a great New Year.
Bind your dropdowns to cfc methods. The documentation on cfinput has examples.
You can do this by means of the bind attribute of cfselect, easy peasy. In fact, the ColdFusion documentation on cfselect has a fully worked out example.
Have a look at the CFM and CFC of the last example. All you have to do is replace States with Banks, and Cities with LoanProcessors. The functions then become getBank() and getLoanProcessors(). Each runs a query. The first function returns an array of banks, the second an array of loan processors for a given choice of bank.