I am using SharePoint 2010.
Here is the functionality I am trying to achieve.
I have a survey with two dropdowns. U.S. States and U.S. Cities.
The first dropdown lists all 50 U.S. States the next question the survey lists 500 of cities in the U.S.
Based on what state the user selects, Ohio for example, I would like the second dropdown to only list the cities for that states. In the case of Ohio, listed would be Cleveland, Cincinnati, Columbus, Dayton, Toledo, etc.
How can I accomplish this in a SharePoint 2010 Survey?