How can I validate two text fields (first and last name) to avoid duplication?
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?