I have geocoded a telephone customer database for assistance in dispatching trouble repair people to customer locations. The database is geocoded by Lat/Lon location of each customer. The data fields I am including in the database are Telephone Number, Name, Address, City, St. ZIP, Longitude, & Latitude.
The only constant information in the database is the Address, City, ZIP and Lat/Lon. Phone numbers and names change over time as people change residences. To keep from making manual changes in the MapInfo table each time a customer moves to another address I am using a current database from our customer tracking system to up-date my Mapinfo table. I do this by geocoding the new file to the address field in the MapInfo table. I have tested this process and it works well if there is only one line entry for that address. ie, the customer only has one telephone number. But if there are multiple instances in either database it won't geocode that entry. EXAMPLE: If a customer has 3 telephone numbers the database lists each phone number in a separate line showing the same address in each line. Does anyone know if there is way to make the geocoder recognize multiple occurrences of the address field.
