Return to FileMaker.com
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...)
The term you are looking for is "Conditional Value List". Do a search for that term and you'll get many variations, one of which is sure to meet your needs.
Retrieving data ...