Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Swathi CseSwathi Cse 

duplicates


i have three fields oreder number,orderrelease number and product no...
i have to compare these three values while inserting the records so that no duplicates
sandeep@Salesforcesandeep@Salesforce
Hi Swathi,

1. If you want to compare these three fields values with respect of separate field for example value of field "a" with value of field "a" of another record then you can just simply enable unique attribute on field level.
2. But if you want to compare value of field "a" with Value of field "b" of same record or another record then you need to write logic in trigger ( Event before Insert). 

Thanks
Sandeep Singhal
Milan Kumar JenaMilan Kumar Jena
Hi Swathi,
Write a trigger or validation rule to restrict the insertion of duplicate records.

Thanks