I have four custom objects. Three objects are linked to the fourth (main) object via a lookup. The fourth main object has an email field. I am looking to auto copy the value of the email address field into the email address field in each of the other three objects. I also want the field to update if the main email address is changed. I have shown a brief overview below;
Custom Object A - My main custom object which contains the master email address field Custom Object B - Lookup field to object A, contains an email address field Custom Object C - Lookup field to object A, contains an email address field Custom Object D - Lookup field to object A, contains an email address field
Email address fields within custom objects B,C,D need to be updated using the main email address field in custom Object A and continued to be updated each time the main email address changes.
Any help would be greatly appreciated.