This is probably very simple. Suppose my data/table has two columns as follows:
Name1 South America, North America
Name2 South America
Name3 North America, Europe
Name4 South America, Europe
Name5 Europe, Asia
I want a drop down list on Region or some form of Region, so that if user selects South America then all Names 1,2,4 display and if user selects Europe, then Names 3,4,5 display. How do I set this up? Thanks for any help.