Hello, Can any one help me understand the concept behind this example:
In the How-To from http://www.zope.org/Members/AlexR/SelectionLists sub section Filling lists from SQL methods, we have a method
<SELECT name="myList"> <dtml-in mySQLQuery> <OPTION VALUE='<dtml-var Field1 null="">'> <dtml-var Field2 null=""> </dtml-in> </SELECT>
How can I create a second list so that when I select Field1, the list is updated from another SQL query using the value of Field1 as the variable.
So for example, I have two tables: ProductGroups and Products ProductGroups has ProductGrpID, Description Product has ProductID, Description and FK_ProductGrpID
Therefore if the user select ProductGrp =1 then the second drop-down menu will only select Products where FK_ProductGrp = 1.
Thanks
Norman