Adding addresses with a form

[Tom Knapp via AccessMonster.com]

OK, Keeping track of addresses has got to be one of the most common uses for
a database. No mattter what type of buiness it is, you need to keep track of
companies, customers, suppliers addresses. What is the best, most accurate,
easiest way to add addresses with a form. Should they be broken down into
street number, direction (N,S,E,W), and street name? Should a drop down list
be used to input the street name? What is the best way for it to look on a
form? How do you assure that they will be input correctly?


Thanks,

Tom

 

[Linda Burnside]

The answer to this question depends upon your particular needs. If your
application of addresses needs to be very specific -- for example, addresses
which will be used in conjunction with a GIS database must be very specific,
otherwise, the GIS cannot find the location -- then yes, you might need that
level of detail. I've personally never done anything more specific than
than to break addresses down to Address1, Address2, City, State, Zip.

Linda