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???