We have a lot of member Company & Location and always increasing, when entering data for a new member Company / Location we have observed that simple City/State names have been add with short name or spelling that don't match. This creates problem while searching for assets based on the city or state information.
When creating/adding new Company / location information we have a text field for entering the City, State & Country information we would like to have a drop down list for selecting the Country, State & City, which should be self validating ( if I select state x it should show all the city's in that state) but at the same time flexible to add more country, states & Cities when ever required( for non-US customers).