Is it possible to relate a task to multiple accounts? I am not wanting to relate to multiple contacts within accounts. I want to pull agreement information into salesforce, and the relationship is with the account, not the contact.
I am making the relationships in SQL and pushing into SF.
Would it be possible to use the EventRelation object in connection with tasks? I could fill in the eventid, accountid, iswhat, and maybe the relationid (if needed). I am building that out now to test.
Is it possible to create a junction object for the many to many relationship? I have one built and tried to make a lookup relationship to the task, but it appears that tasks cannot be parent objects. Or am I perhaps missing something?
I really do not desire to create multiple lookup fields to the account. The end goal is to be able to include these activities in reports based on each account. Would I just have to bite the bullet and build joined reports with these "activities" on a custom object?