I recently imported the allcountries.txt and countryInfo.txt into my MsSQL database. What is the best way to have multiple chained dropdown lists to find out someone's city. For example:
I would say it depends on how many cities you are using and which countries you are dealing with. If you use all 2 million populated places it will become a pretty large dropdown list for some countries.
Is there documentation on this column admin1Code? I am having trouble figuring out how to related the columns.
For example how would I find the following in the database:
US -> California -> Los Angeles
I think the Fipscode for California is 06, but when i typed that into admin1Code column the countryCode was not 'US'. How can I find more information on how to relate the columns?