No Duplicate Emails

FileMaker Pro has some very simple and straight-forward validation options. For example, if you only want one field named email to only ever have a single copy of a given email, you choose the Unique option in the Validations section of the field's options.

But, what if you want to allow a given contact record to have multiple email addresses. How do you check for uniqueness across multiple fields? The same email could appear within one field and then would be perfectly valid in a second field which doesn't contain the original email.

Well, here's the solution. Watch this video and use the provided technique file to simply copy the solution into your own FileMaker database. We'll use some creative tricks in order to make the process both robust and very powerful!

AttachmentSize
NoDuplicateEmails.zip1.61 MB

Comments

non-commit GOLD ! thanks so much
several things learned