I created a junction object called
Sponsorship__c and have a many-to-many relationship. It is related to Contact through a master-detail relationship and I have another custom object called
Sponsored_Child__c which also has a relationship with
What I need to do is create a trigger that updates a Contact field once a new Sponsorship is been created or updated. That field is
Child_Names__c and once a Sponsorship is created, the first name(
Sponsored_Child__c) of the Child is concatenated to the field
Child_Names__c of Contact.