You need to sign in to do that
Don't have an account?

Save record only if it matches with any value of another field in the same custom object(Validation)
I have a Custom object Object__c with field Paper_ID__c(Text datatype). I want to create another field Paper2__c it should allow me to save the record only with any one of the Paper_ID__c field value.
Paper_ID__c(Field name)
Record1 123455
Record2 123456
Record3 123457
Record4 123458
Record5 123459
Paper2__c field should allow me to save only with 123455 OR 123456 OR 123457 OR 123458 OR 123459.
If not it sholud through error. Please guide me in this.
Paper_ID__c(Field name)
Record1 123455
Record2 123456
Record3 123457
Record4 123458
Record5 123459
Paper2__c field should allow me to save only with 123455 OR 123456 OR 123457 OR 123458 OR 123459.
If not it sholud through error. Please guide me in this.
Use a validation rule.

Thanks for your reply Steven. My bussiness added one more criteria. I have done using Trigger.