function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Phuc Nguyen 18Phuc Nguyen 18 

Copy fields values to other record

Hello All,
Going in circles over how to resolve this.
I have Object Projects.  
The Project has a lookup to an Account
The account can reside on multiple Projects

So Project 1, Project 2, Project 3 all have the same loopup record 'Account Test'
So if field 'user' is Updated on Project 1.  How can I update the 'user' field on Project 2 and Project 3. 


Best Answer chosen by Phuc Nguyen 18
Suraj Tripathi 47Suraj Tripathi 47
Hi Phuc,

Check this code:-
trigger updateUser on projects__c(before update){
  map<id,id> accidVsOwnerid = new map<id,id>();
  for(project__c pro: trigger.old){
 List<account> accList=[select name,ownerid from account where id IN: accidVsOwnerid.keyset()];
 List<project__c> proList=[select name.ownerid,accountid__c from project__c where accountid__c IN: accidVsOwnerid.keyset()];
 List<project__c> updateList= new List<project__c>();
 for(account acc: accList){
   for(project__c pro: proList){
  update updateList;

​​​​​​​In case you find any other issue please mention. 
If you find your Solution then mark this as the best answer.