Hi,

I want to update the Parent Account Lookup field in account record using after insert and after update trigger. The condition to update the parent account lookup field is that if recruiter id of account record matches with the parent account the corresponding record will be updated in parent account lookup field of account record.

I am trying with the following code but getting error:

trigger UpdateParentAccountInAccount on Account(after insert, after update)
{
    List<string> lst_RecID= new List<string>();
    Map<String, Id> map_ParentAccounts = new Map<String, Id>();
   
    for(Account acct : Trigger.new)
    {
        lst_RecID.add(acct.Recruiter_ID__c);
    }
   
    for(Parent p : [  Select Id,
                                    Recruiter_ID__c
                               From Parent
                              Where Recruiter_ID__c In :lst_RecID])
    {
        map_ParentAccounts.put(p.Recruiter_ID__c , p.Id);
    }
   
    for(Account acct : Trigger.new)
    {                          
        if(map_ParentAccounts.containsKey(acct.Recruiter_ID__c) == true)
        {
            acct.Parent = map_ParentAccounts.get(acct.Recruiter_ID__c);
        }
         else
        {
            //throw error ...
           
           // adb.addError('You can\'t insert Active_Database record without Account Number!');
            return;
        }      
    }   
}

Any suggestion will be helpful for me.

Thanks,