How to handle many-to-many relationships in reporting
Hi Reporting Experts! I'm hoping you can help me with this one... I needed to set up a many-to-many relationship between Contacts and a CBO called Assisters. So, I created a join table CBO (Contacts2Assisters) that has 2 fields, Contact and Assisters, and I set up both objects as Parents.
I have a report in the Contact workspace that shows all the Assisters that are associated to that Contact. That was easy - I did a join with Contacts2Assisters as the root and Assisters and Contact connected by inner joins to that. I added a filter by Contacts2Assisters.Contact. Works as expected.