+ Start a Discussion

Avoid Duplicate records in an custom object

Hi,Can any one help in validation rule or any way to sort this on the following:
in an object we have fields A,B,C,D,E, all are lookup fields which are related to same parent object ,when a record got inserted into the object.
like A           B            C                 D                  E

prod A     prod B     Prod c      prodD                                 have to insert 
Prod A    Prod B                                                           should not insert
Prod A                   Prod E                                            Should not insert
Prod A     Prod F                                                             Have to insert
Prod A     Prod F   Prod G                                            Should not insert

Prod A  A field can have multiple Records with B field same r value of B is not allowed and once Prod A Record have C,D,E values again should inert values of same record..
Please can anyone help on this ..Thank you.
VinayVinay (Salesforce Developers) 
Hi Anitha,

Did you try to use duplicate rule in salesforce?