[AccessD] Street names in the separate table

Ervin

This has been a problem since databases first began. I don't know of any
Soundex-type solutions, but I was able to reduce duplications by almost 90%
by using combo boxes with automatic dropdown activated. By seeing all of the
available choices as the user input their data, they seemed willing to make
the effort to find an existing entry rather than add a new one. Also, on the
NotInList event, I used a small popup form, which further 'convinced' users
that using the data in the list was preferable to just adding a new one
because they were too lazy to look it up.

Bob Gajewski

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Ervin Brindza
Sent: Friday, June 25, 2004 01:41
To: AccessD at databaseadvisors.com
Subject: [AccessD] Street names in the separate table


I was wondering how to manage the "street problem" because my customer like
to use different abbreviations for the very same street name. Are there any
method(like soundex) to check is the street already entered?
E.g. the street names:
King George III
K. George III
King George the Third
etc.
TIA,
    Ervin
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com