hi friends,

i have requirement to prevent dupilcate records on related list (products) which is child for case.

I got the duplicate code working fine on the productline object independent of case, however now i want to make it work as part of case since requirment is to prevent duplcate on related list product line.

so i need to now check all the products on product line as part of parent object case and then prevent user from entering duplicate, how do i reference case from child object productline?

thanks

trigger pp on Product_Line__c (before insert, before update) {
//private list<Case> caseemlist;
//caseemlist=new list<Case>();
Map<String, Product_Line__c> Prodmap = new Map<String, Product_Line__c>();
for (Product_Line__c Pl : System.Trigger.new) {

// Make sure we don't treat an Products__c that
// isn't changing during an update as a duplicate.

if ((Pl.Products__c != null) &&(System.Trigger.isInsert || (Pl.Products__c !=
System.Trigger.oldMap.get(Pl.Id).Products__c)))
{

// Make sure another new Product_Line__c isn't also a duplicate

if (Prodmap.containsKey(Pl.Products__c))
{
Pl.Products__c.addError('Another new Product has the '
+ 'same Products');
} else {
Prodmap.put(Pl.Products__c, Pl);
}
}
}

// Using a single database query, find all the Product_Line__cs in
// the database that have the same Products__c as any
// of the Product_Line__cs being inserted or updated.

for (Product_Line__c Pl : [SELECT Products__c FROM Product_Line__c
WHERE Products__c IN :Prodmap.KeySet()]) {
Product_Line__c newpl = Prodmap.get(Pl.Products__c);
newPl.Products__c.addError('This product '
+ 'already exists.');
}
}