+ Start a Discussion
Jacob W LandisJacob W Landis 

how to make a report join two relationship objects

Hi, 

We have custom objects, Event, Contact, Account, Event with Contact(master-detail relationship with Event and Contact), Contact with Account(master-detail relationship with Contact and Account). We would like to have a report which show the event with the contacts and its accounts if there is any. Any ideas how to do it? I tried to use join report, and pick two relationship objects, but the contact is not listed as common field. Any ideas?