dropdown box on change event in SharePoint list forms

Question

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.

Answer 1

This can be achieved with InfoPath, as it described here:

• Cascading dropdown list in SharePoint 2010 using InfoPath 2010 article by Nguyen Ba Quang
• Create cascading list box using InfoPath article on office.microsoft.com

The other option is to use SPServices and its SPCascadeDropdowns functionality:

• SPCascadeDropdowns documentation on CodePlex