|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Hi Folks.
I am having a tough time trying to decide how to design my tables that will hold address information for a user, like city, State, Zip and Country. Are there any best practices to follow? I can imagine that the tables should be Country, State and City OR can be Zip with a one to many relationship. My second question is; any best practices to display the country data on web forms so users can select country, then state and then city? I am building with ASP and Access 2K. Thanks for your input. ![]() |
|
#2
|
||||
|
||||
|
here's a great article --
Usable Forms (for an international audience) http://evolt.org/international_forms as far as table design is concerned, i would not attempt to create one-to-many relationships with city, state, or zip codes rudy http://r937.com/ |
|
#3
|
|||
|
|||
|
Thanks rudy, that is an excellent overview.
|
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Best solution to hold Address information |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|