AnsweredAssumed Answered

How can I validate two text fields (first and last name) to avoid duplication?

Question asked by FranziskaBlome on May 22, 2014
Latest reply on May 22, 2014 by FranziskaBlome

Title

How can I validate two text fields (first and last name) to avoid duplication?

Post


     Hi! I know how to validate one text field, say "last name", but since there will be duplicate last names in a large contacts database I would like to validate that both "first" and "last name" don't already exist in this database. How do I do that? I also have a calculation field combining first and last name into one field, but I don't see how I can set a validation on this calc field. Any suggestions?

     Many thanks!

     Franziska

Outcomes