I have a custom object called Project__c that has two child objects:1) Targets__c (multiple Targets per Project)2) Period__c (multiple Periods per Project).Each Target__c has fields Year (e.g. 2021) and Yearly target.Each Period__c has fields Quarter (e.g. 2021 Q1) and Yearly target.I need to update Yearly target field on Period object every time new Period is created (or if its quarter field is updated). For example, if Period[i].Quarter is "2021 Q3", the value of "Period[ i ].Yearly target" must be assigned whatever is entered in "Target[ j ].Yearly target" when Target[ j ].Year = Year[Period[ i ].Quarter].How can this be achieved? I assume a triger on Period__c object and some SOQL magic is necessary?
