Select Case Statement Advice

[BobbyOH]

When customers call us we always get their phone number but not always their
town. There are about 12 towns in the area and all use the same area code. I
was thinking of doing a select case statement based on the prefix that when
the phone number is entered, the town would fill in automatically.

Would that slow down the database significantly or is this even something I
should consider doing?

Does anyone have any ideas other than making sure we ask for the town name?

As always thanks for your help...

Karen

 

[Wayne Morgan]

Most folks do this based on the zip code. Whether or not this would work for
you depends on your area and how accurate you want the town information to
be. In the area that I live, the prefixes are available to anyone in any
town served by the same telephone switching office. You will see this if you
look at your long distance bill, some of the numbers you call won't show the
town you actually called. Instead, they will show the town that the
switching office is in.

As far as it slowing down the database goes, it should be faster than typing
it in manually. I just don't think you'll get the information as correct as
you want it.