|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
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
October 17th, 2003, 03:47 PM
|
|||
|
|||
Best solution to hold Address information
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
October 17th, 2003, 05:57 PM
|
||||
|
||||
|
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/
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Best solution to hold Address information |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
