Two consecutive dropdown lists
I have ten product lines and each product line have 10 to 15 products. The products are not similar and do not cross over.
How can I set up the second dropdown menu (Products) to to reflect only to what is chosen in the (Product Line) field.
Product Lines: Pens, Pencils, Highlighters...
Products: (Ballpoint, fountain, rollerball...), (#10, mechanical, color...), (yellow, blue,red...)