+ Start a Discussion
Swathi CseSwathi Cse 


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
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). 

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