In the wizard the options I'm presented are products for the Array source, select "brand" in form "WADAInsertForm" for the Source List (this field holds brandName from the products table) and select "product" in form "WADAInsertForm" (this field holds the proposed productName to be inserted into the products table. All fields are from the products table.
The products table field list is as follows:
id -- this is an autoincrementing field that serves as the primary key for the table
brandID -- this corresponds to the brandID field in the brands table
brandName -- this corresponds to the brandName field in the brands table
productName -- obviously . . .
I see where the parameters passed in the onChange statement include brand, not brandID. I presume this is picked up from the Source list. The brandID is not available as a var on the page anywhere. If I manually edit 'brand' to 'brandID' in the onChange statement there is still no Child list.
Where do I change the selection from 'brand' to 'brandID'??
Thanks --- I'm probably overthinking this or missing something simple. .
Mike