AnsweredAssumed Answered

Allowing Unique Values Only

Question asked by MarkMcCoy on Nov 3, 2010
Latest reply on Nov 7, 2010 by MarkMcCoy

Title

Allowing Unique Values Only

Post

I have a contact database that has two separate fields for email addresses.

  • Email Primary
  • Email Secondary

I have already set the database to only allow unique values in the email primary or in the email secondary fields but have been unable to find a way to link the two together and ONLY allow a unique email address to appear in either one of the fields.

For Example, it's setup to avoid this situation

Contact #1

Primary: mark@test.com

Contact #2

Primary: mark@test.com

What it WILL let me do and what I want to avoid is

Contact #1

Primary: mark@test.com

Contact #2

Primary: info@test.com

Secondary: mark@test.com

Thank you for looking!

Outcomes