We have three lookup fields on our Account page to a custom object we created called 'Partners':

Email_Provider__c

Social_Media_Management__c

Facebook_Ad_Platform__c

We also have a junction object called 'Account/Partner Relationship' that includes a lookup field to Accounts and a lookup field to Partners.

Basically, if someone populates one of those three look-up fields I listed at the top, we want a new Account/Partner Relationship record to be created with the Account being populated in the account look-up field and partner chosen in the partner look-up field.

I'm assuming We need a trigger to do this, but I have zero experience with APEX code. Any help would be greatly appreciated. Let me know if you need more information from me.

Thanks!