Hello,
I'm currently modelling the user profile of my current project (in Rails btw). The user should be able to set the country, state and city he lives in. Instead of doing this through simple input fields I'd like to have some - kind of - nested selection boxes.
I think of it like this: first select your continent. Then a list with the countries of the selected continent appears. Then choose a state based on the selected country. etc.
Do you know a database schema with the required data? I'm pretty sure something like this must exist - I just can't find it! ;)
Optimal case would be, if the names of countries and cities are already in localized state. I think it's quite comfortable for the user to select his home location in his native language! ;)
Thanks for your helpful answers!