I'm looking into junction tables and custom objects to relate contacts to multiple accounts in Marketo. I've found a few posts around the community (thanks @Grégoire_Miche2 and @SanfordWhiteman), but want to ask a few clarifying questions.
Thanks in advance for any advice.
If you're thinking about junction tables in Marketo only that ain't going to happen. You can't relate Marketo objects to SFDC objects like this. The relationships need to exist in SFDC.
@SanfordWhiteman, so the Account Contact Relationship object exists in Salesforce by default, but Marketo doesn't support the object with the basic Salesforce integration, hence each contact is only tied to 1 account. The Salesforce object is pretty basic (which I'm sure you're familiar with), basically a lookup based on ContactId and AccountId, along with a few other fields. My assumption is that if you replicate that functionality in Marketo, the only thing you're going to be able to see are the field directly on that object, correct? Whereas in Salesforce the lookup to the Account allows you to filter based on the account behind the lookup.
Sorry, I'm just not seeing a clear direction to go with this.