I have a SharePoint 2010 List with two columns, State and City. State is populated with a list of states while City is populated with a list of cities. The City list also has a State column. I want to filter the City list according to the selected state. How can I achieve this without using InfoPath, SharePoint Designer or a web part. I want to do it only in SharePoint. Is that possible to give a message when they select the city stating "Please select State before selecting a City"? If any JQuery or JavaScript will be used then how can I use that.
Populate sharepoint list column based on another column value
sharepoint
Best Answer
Use Managed Metadata instead. Create a tree with the states and the cities and then add that as a column instead.
http://www.sharepointnutsandbolts.com/2009/12/managed-metadata-in-sharepoint-2010-key.html