You need to sign in to do that
Don't have an account?
![SFAdmin5 SFAdmin5](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
bulkify trigger
i was bulk testing this trigger and while it works in the ui i get this error:
"setParentFieldsFromChildTriggeronProgram: execution of BeforeInsert
caused by: System.ListException: Duplicate id in list: 006G000000JvcxjIAB
Trigger.setParentFieldsFromChildTriggeronProgram: line 27, column 1"
Here's the trigger.
trigger setParentFieldsFromChildTriggeronProgram on Program__c (before insert, before update) { List<Opportunity> oppList = new List<Opportunity>(); Set<id> Ids = new Set<id>(); for (Program__c prgm : Trigger.new) { Ids.add(prgm.Opportunity__c); } Map<id,Opportunity> oppMap = new Map<id,Opportunity>([Select Id,Product_Group__c,Product_Area__c,Product_Family__c,Product_Family_Child__c from Opportunity Where Id in :Ids]); for (Program__c prgm : Trigger.new) { Opportunity o = oppMap.get(prgm.Opportunity__c); o.Product_Group__c = prgm.Product_Group__c; o.Product_Area__c = prgm.Product_Area__c; o.Product_Family__c = prgm.Product_Family__c; o.Product_Family_Child__c = prgm.Product_Family_Child__c; oppList.add(o); } update oppList; }
Instead of list take map and update oppList, list allowes duplicates, map does not allow duplicates