Just for information, we receive the data from a shop till system whereby the primary key is a concatenation of the customers forename, surname and date of birth. This...
The customer table actually has all the address fields in there. The software that I use finds duplicates based on the customers initial, surname, property and postcode. ...