Searching for duplicates

[jdenver]

Ive created a table for customers. Whilst entering a new customer record I was wondering how to automatic search to see if the customer exist before committing the new customers record. As it stands at the moment the new record is created at the start so I would have to delete the record if a duplicate exists.

Any ideas on doing this and advice please would be appreciated.

[Lee Smith]

Hi jdenver,

Check out the Options for the fields, Options »» Validation Tab »» Require »» Unique options.

Lee

[jdenver]

Not sure that would work Lee. The customers table contains fields: first name, surname, house number/name, 1st line off address, 2nd line off address, town, country and postcode. So I would need to search the whole record for a duplicate. Most fields have dropdown lists on them so the date is spelt the same ie road name etc.

Unless I'm missing something.

[Lee Smith]

Here is a short video by John Mark Osborne https://www.youtube.com/watch?v=9_8YXRAoJbE

 

That may help to explain.

You will need to include other fields you are validating. Nothing is entirely user proof.

[jdenver]

Spot on Lee thanks, Im finding its works for duplicates but if I carry out the test John Mark Osborne done during the video (at 2:18 into the video) of deleting a character and adding it back, a duplicate massage still shows up even though Ive added the id ≠ id relationship. Does anyone have any ideas on why this is happening.