5 Replies Latest reply on Oct 29, 2015 12:21 PM by sydbarker

    How to prevent a duplicate contact?

    sydbarker

      In my contacts database, what I need to do is create a script trigger that once a First Name and Last Name matches an existing contact, the message will pop up "A contact for John Smith with Global Industries already exists. Do you wish to continue?"

      What I am having trouble figuring out is how to get it to check all records for John Smith. I know that some people could have the same name, but work for different companies and I am trying to get around requiring a unique value.

      Any suggestions on how to do this?

       

      Thanks in advance!