
October 17th, 2003, 03:47 PM
|
|
Contributing User
|
|
Join Date: Oct 2003
Location: Los Angeles, CA
Posts: 64
Time spent in forums: 2 h 51 m 7 sec
Reputation Power: 10
|
|
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. 
|