Dropdown selection based on fields?
I'm not 100% percent sure how to word this, but I need a dropdown menu to show only a certain selection based on a field.
I will explain what i'm doing. I have a form with three fields. One is Manufacturer, One is Product, and the third is Product color. The Manufacturer and Product field automatically are populated based on a checkbox selection I have of products. So based on what they click on the checkbox, I want the drop-down to only display product colors based on the Product that was chosen.
Is there a way to do this? Maybe some sort of script? I am open to all ideas or better alternative on how to approach this.
I inserted screen shots of the form I have to give you a better idea.


