+ Start a Discussion
Joshua Bloom 12Joshua Bloom 12 

I want to create a validation rule on our acquisition object that does not allow duplicate information to be inputted in the address field. The record will display an error if the same address is inputed as another already saved record

can create an apex trigger that will capture the duplicate information using the validation rule for a custom object
Prakash NawalePrakash Nawale
Hi Joshua,

You need to create trigger on your custom object.
Write trigger on before insert/update
In trigger collect address in set then do SOQL query on custom object with where cluse.
if match found the add error to record.

 
prateek jainprateek jain
Hi Joshua 
You don't have to write a trigger  and all that stuff, simply make a duplicate and matching rule for it it would be easy.
Thanks