You need to sign in to do that
Don't have an account?
Joshua 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
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.
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