When a customer places an order he is obliged to enter an email address. When he places the next order the system automatically associates it with the previous order through the email address. But if he makes a mistake with his email address the system sees him as a new customer.

What I want to do is to combine the two records into one. But if you go to correct the email address that is wrong it says that that email address that you change it to - the correct one - is already in use. Which is true, but that is just the point - I want this 'new' customer record to be associated with the old one.

If I haven't totally confused you yet, is there a way of doing this?

Thanks

Willem