Hi,

I am trying to update a field value on standard object after there has been a change on a custom object field.

The standard Object is Account and custom object is  Accountsinaction(Account_in_action__c).

Both objects are related via a Lookup relationship. The field is Account__c on Custom Object.

Also, the custom object has another field called Account_Status__c. If there is a change to this value, a trigger has to fire and update the change in corresponding Standard Account Object.

Trigger Code so far:

trigger Update_Account_Status on Account_In_Action__c (after Update) 
{
      List<Account> accts_toUpdate=new List<Account>();
      Set<Id> accsId =new Set<Id>();
      
      for(Account_In_Action__c ia : Trigger.New)
          accsId.add(ia.Account__c);
          
      Map<Id,Account> AccountMap=new Map<Id,Account>([Select Status from Account where Id in :accsId]);
      List<Account_In_Action__c> account_Action= [select Account_Status__c from Account_In_Action__c where id in :Trigger.new];
      
      for(Integer i=0;i<account_Action.size();i++)
      {
        Account toupdate=new Account();
        accountMap.get(account_Action[i].idea__c).Status=account_Action[i].account_status__c;
        accts_toUpdate.add(toupdate);
      }
      
      if(accts_toUpdate.size()>0)
          Update accts_toUpdate;
}

 It gives following error msg:

System.SObjectException: SObject row was retrieved via SOQL without querying the requested field: Account_In_Action__c.Account__c: Trigger.Update_Account_Status:

Can anyone help me with this.

Thanks in advance !

sales4ce