State and cities based on county And state
I want to create 3 dropdowm field like Country,State,and City. State dropdown list has to show only states from selected country and city dropdown list has to show the cities from the selected stat...
Forum Discussion
How can i get list of all the countries and related states and cities
------------------------------
Chethana Shetty
------------------------------
------------------------------
Chethana Shetty
------------------------------
Hi Cethana,
Below is a list of states. This link might be able to provide the list of US cities, but a Google search can give you more options. http://www.opengeocode.org/download.php#statecity
You can copy and paste/import the state list into a table. You would also want a Cities table which you can relate the states.
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming
------------------------------
Ben L
------------------------------
- Thank you for your time and suggestion.
------------------------------
Chethana Shetty
------------------------------
