Greetings,

I have a customer list of which 70% have only one entry per customer.

The problem is the oddballs:

Customers who change their names (get married)
Customers who change their address
Customers with more then one service address (Real estate agents)
Customers who have more then one phone number or change their phone
numbers
And customer who nave many of these exceptions

I would like to have one record per customer. What I have is a
separate record for any changes that occur.

Is there anyway to redesign this customer list to limit it to one
record per customer?

Any suggestions would be most appreciated

TIA

-Minitman