Click here to Skip to main content
15,881,173 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all,

I'm wondering which would be the right way to enter a place in the database...

Let me explain it:

I have a table named tPlaces which includes fields like:

Country, State/province, City, Postal code, GPS coordinates, name of this place, ...
When I want to enter a new place, probably some of the data will exist already:

Multiple customers from the same country...

When I have to enter the new country, I could add a combobox in the form, but that would be helpful only if the country is already introduced into the database.
Same would happen with the city...

I could put an editbox with some ajax to reduce the list possibilities while I write (OnKeyUp...) but this would end giving me a country name in a variable.

Or I could add a combobox and an editbox... and, if I change the combobox it should overwrite the value of the editbox...

What is done in situations like this to make it easy for the user?

Thank you all...

What I have tried:

Searching for form examples...
Posted
Updated 29-Sep-19 3:29am

1 solution

 
Share this answer
 
Comments
Joan M 30-Sep-19 5:32am    
Even it's clever, it doesn't work in most of the addresses I've checked from customers in Spain... :( Thanks anyway.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900