CiviCRM Community Forums (archive)

I'm trying to use Views to display a single Organization contact + a set of contacts that are defined by a relationship type "Location of" the primary Organization.

I'm having trouble understanding how to describe this relationship in Views -- what View type is appropriate, and how to set the Relationship and Filters.

Can anyone provide any pointers?

This put me on the right track.

The issue I was struggling with stemmed from the fact that I was trying to display the primary contact (Central Office) and the associated child contacts (Locations) in the same view. I think this is do-able with attachments, but I find that the views interface gets somewhat confusing when the attachment differs significantly from the default view.

To make a long story short, I solved it using a Panel and two different views, one that pulls the central contact record and one that pulls the associated child location records. My "associated locations" view uses your recipe and modifies the filters slightly:

CiviCRM Contacts: Contact Type = Organization
CiviCRM Address: Location Type = Main (necessary so that it doesn't return both Main and Billing address)

Thanks for the help!