Validation rule: Duplicate_Account1_Contact1_must_be_pair

Name

Duplicate_Account1_Contact1_must_be_pair

Label

Duplicate_Account1_Contact1_must_be_pair

Object

Case

Active

Yes

Formula

AND( RecordType.Name = 'Duplicate Account/Contact',
NOT(ISBLANK( Usyd_Potential_Duplicate_Contact_1__c )),
NOT( OR( Usyd_Potential_Duplicate_Contact_1__c = Usyd_Potential_Duplicate_Account_1__r.AQB__PrimaryContact__c ,
Usyd_Potential_Duplicate_Contact_1__c = Usyd_Potential_Duplicate_Account_1__r.AQB__SecondaryContact__c)))

Error message

Potential Duplicate Contact 1 must be either primary or secondary contact of Potential Duplicate Account 1.

Error location

Top of Page

Description

If duplicate Contact1 selected then it must be either Primary or seondary of the Account