Body: <p>Hoping for a little advice on the best way to address the following situation.</p>
  
  <ul>
  <li><p>We have individuals with relationships to organizations.  Each individual can have multiple relationships to organizations; each organization can have multiple relationships to individuals.  </p></li>
  <li><p>Relationships have custom fields.</p></li>
  <li><p>Based on a query against the custom fields, the client wants to use tools (exports, mailing labels, etc.) which combine fields from both the individual and the organization.</p></li>
  </ul>
  
  <p>A concrete example:</p>
  
  <p>We want to generate a mailing to "delegates".  Each individual could be a delegate for many organizations, and each organization could have many delegates.  Whether or not an individual is a delegate is determined by a custom field in the relationship.</p>
  
  <p>We need to generate an exports and mailing labels which include the name and phone number of the individual, and the name and address of the organization.</p>
  
  <p>Thoughts?</p>
  
  <p>Thanks!</p>
  
  <pre><code>        Sam
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-08-29T15:29:17.720Z
Comments.Text: Hi - as per my forum feedback, can you provide an example of what the table would look like for John, Mary and Bob and Org X. Y and Z? Do you want a single row for John and 'all' his organisations as columns, or a row for each time he is a delegate, or grouped by Organisations, or by person, etc etc.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-08-31T11:58:28.590Z
Comments.Text: Alice, Bob, and Charlie are affiliated with organizations X-Ray, Yankee, and Zulu.  In particular: Alice is a delegate for X-Ray and Yankee; Bob is a delegate for Yankee and Zulu; Charlie is a delegate for Zulu only. 
  
  We want to output five mailing labels, one for each relationship; each label would include the individual's name and phone number, as well as the organization's name and address, as well as fields from the relationship (role, etc.)
  
  If the answer to this is just Drupal views ... I can figure it out from there.  Just wondering if there was an answer within Civi.
Comments.UserDisplayName: Sam Nelson
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-08-31T21:30:38.357Z
Comments.Text: okay so a row per relationship. i would go Views. either based on Contact, or based on Relationships
Comments.UserDisplayName: petednz - fuzion
Tags: <custom-fields><export>
Title: Mailing labels with multiple relationships
ThreadText: # Mailing labels with multiple relationships
  
  (Asked by: username_0 on 2016-08-29)
  
  Hoping for a little advice on the best way to address the following situation.
  
  We have individuals with relationships to organizations.  Each individual can have multiple relationships to organizations; each organization can have multiple relationships to individuals.  
  Relationships have custom fields.
  Based on a query against the custom fields, the client wants to use tools (exports, mailing labels, etc.) which combine fields from both the individual and the organization.
  
  A concrete example:
  We want to generate a mailing to "delegates".  Each individual could be a delegate for many organizations, and each organization could have many delegates.  Whether or not an individual is a delegate is determined by a custom field in the relationship.
  We need to generate an exports and mailing labels which include the name and phone number of the individual, and the name and address of the organization.
  Thoughts?
  Thanks!
          Sam
  
  **Tags:** custom-fields, export
  
  > **Comments:**
  > **username_1**: Hi - as per my forum feedback, can you provide an example of what the table would look like for John, Mary and Bob and Org X. Y and Z? Do you want a single row for John and 'all' his organisations as columns, or a row for each time he is a delegate, or grouped by Organisations, or by person, etc etc.  
  > **username_0**: Alice, Bob, and Charlie are affiliated with organizations X-Ray, Yankee, and Zulu.  In particular: Alice is a delegate for X-Ray and Yankee; Bob is a delegate for Yankee and Zulu; Charlie is a delegate for Zulu only.   We want to output five mailing labels, one for each relationship; each label would include the individual's name and phone number, as well as the organization's name and address, as well as fields from the relationship (role, etc.)  If the answer to this is just Drupal views ... I can figure it out from there.  Just wondering if there was an answer within Civi.  
  > **username_1**: okay so a row per relationship. i would go Views. either based on Contact, or based on Relationships  
  
  ---
  
  ## 0 answers
  
  