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!