Hey guys-

I need to create a trigger on the account object that does the following:

• Look at the Account Owner’s User Record
• Look at the “Region” field on the User Record
• Update the “Apex Region” field on the Account Object based on the Region value from the User’s Record

I have a similar trigger that works perfectly for a text field, but I would like to set this up as a picklist (for easier reporting).

Here’s the code that I'm trying (it complies but doesn't update the picklist)-

trigger ApexTestTrigger on Account (before insert, before update) {

// create a set of all the unique ownerIds  
       Set<Id> ownerIds = new Set<Id>();  
       for (Account a : Trigger.new)  
           ownerIds.add(a.OwnerId);      
     
    // query for all the User records for the unique userIds in the records  
       // create a map for a lookup / hash table for the user info  
       Map<Id, User> owners = new Map<Id, User>([Select Region__c from User Where Id in 
       :ownerIds]);     
     
       // iterate over the list of records being processed in the trigger and  
      // set the Region before being inserted or updated  
      for (Account a : Trigger.new)  
           a.Apex_Region__c = owners.get(a.OwnerId).Region__c;   
}

 Help would be greatly appreciated!