kimtim1402
New Member
Hi,
What is the best approach to filter from an auto-complete zip code field the city field.
The other way is simple, but this way seems really heavy.
I tried 3 different ways:
How can I found a solution ? please help me, because I am really desperate.
Thanks
Kosta
What is the best approach to filter from an auto-complete zip code field the city field.
The other way is simple, but this way seems really heavy.
I tried 3 different ways:
- 1 table solution
Zip codes and cities in the same table
Databasejoin (auto-complete) zip code
Cascadingdropdown city - 2 tables solution
Zip codes table connected with cities table via zip-city-id
Databasejoin (auto-complete) zip code
Cascadingdropdown city - 3 tables solution
Zip codes table connected with zip-cities table via zip-id
Cities table connected with zip-cities table via cities-id
Databasejoin (auto-complete) zip-cities table, label zip code
Cascadingdropdown zip-cities table, label city
How can I found a solution ? please help me, because I am really desperate.
Thanks
Kosta