Adding addresses with a form

  • Thread starter Thread starter Tom Knapp via AccessMonster.com
  • Start date Start date
T

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
 
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
 
Back
Top