title: Populate sharepoint list column based on another column value
body: <p>I have a SharePoint 2010 List with two columns, <code>State</code> and <code>City</code>. <code>State</code> is populated with a list of states while <code>City</code> is populated with a list of cities. The <code>City</code> list also has a <code>State</code> column. I want to filter the <code>City</code> 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.</p>