Skip to Content
0
Former Member
Aug 20, 2008 at 05:55 PM

Valadation syntax to limit one contact entry per contact function

11 Views

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.

thanks

Tammi