I am editing an SharePoint list form using SharePoint Designer. I need to have two drop down boxes one with the names of the countries and other with the names of appropriate state. How can I achieve this using SharePoint Designer?
Since the state's column will have different state values for different countries, how do I set the column up? What I mean is, country column can be a lookup field in another list which have all the country names in it. How to setup the state column since it has to change for each select.