Our main MDM table is Customers. We have a Qualified Table for Contacts. I would like to limit data entry in the Contacts table to one contact if the Contact Function = Primary. I have tried different validations but none work. Is there a where clause available when writing validations.
Then we can syndicate the Primary contact information to other applications and ensure that only one Primary contact exists in the repository.