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.

Hi jdenver,

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

Lee

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.

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.

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.