Item Chosen in One DropDown Filters the Items in a 2nd Dropdown

I have two tables; product type and product.

A product is of one and only one product type and a product type could be the type for zero, one or many products.

On my app, I want users to FIRST select the product type from a drop down, and then SECONDLY select the product from a second drop down. But I want the list of items in the 2nd drop down to be based on the product type selected in the first.

How???

This topic was automatically closed after 70 days. New replies are no longer allowed.