Welcome to WebmasterWorld Guest from 126.96.36.199
Rather than having a collection of reservation records containing disparate unrelated customer names, it would make sense to have a main ‘customer’ database. The problem is how do we ‘match’ the customers from various bookings. We shall have a name and address in the vast majority of cases (and an email case in some, but not all, cases), but we can’t guarantee that the customer or tour operator will have entered/spelled the details exactly the same in any case. We certainly can’t rely on the customer providing a customer or reservation number – in fact they may have booked their accommodation through one of the agencies tour operators and then book car rental and tours directly from the client’s website without realising any connection until they arrive.
Has anyone got any clever ideas of the best way to take form data and reliably match the customer’s details with existing database records?