I am using ColdFusion to develop an application, and I've run into an obstacle.
My 'product add' form allows the user to select a BRAND, and then a PRODUCT LINE within that brand (2 separate fields). These form elements are populated dynamically, but I need the second (PRODUCTLINE) to only populate after the user selects a BRAND. That way, I can filter the query so that they cannot select a PRODUCTLINE that doesn't belong to that BRAND.
Either way, what is the best way to code this?