Allowing Unique Values Only
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
What it WILL let me do and what I want to avoid is
Thank you for looking!