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
participants (1)
-
Norman Khine