You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!