function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
XactAndyXactAndy 

Navigating many to many relationships using custom reports

Hello,

I'd like to be able to navigate over a number of many to many relationships using
the new custom report types. We've implemented m-to-m relationships
using intermediate object types. However, when creating the report, I
can only navigate from the source object to the intermediate object
and no further. Is there any way around this, or is it a case of generating
this kind of navigation data using an S-Control?

Thanks,

Andy


tttt
You can do this using the Custom Report Types feature in Summer'07.
Join from your first object to the intermediate object, then save the CRT.
Use "Edit Layout" to get to the page layout, and then select the intermediate object in the object selector, and use the "Add fields via Lookup" to fetch the fields from the object on the other side of the join.
You can then save this CRT and use it to create reports from fields on both sides of the join.
XactAndyXactAndy
Thanks.

That allows me to bridge the gap from object 1 via a relationship object to
object 2's fields. However, what I need to be able to do is navigate to object
2 and then navigate via another relationship object to object 3 and so on.
Is this possible?

Andy