Populate sharepoint list column based on another column value

Question

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.

Answer 1

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

Answer 2

You can use JavaScript, but to do it you need either Sharepoint Designer or a web part .... So in JavaScript you could use SPService or SPJS