Answers.Body: <p>It appears the View you are using is starting from the entity CiviCRM Relationship. This is unusual in my experience. I would be building a View based on Contacts and then adding the Related Contacts by using the View Relationships to pull them in.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-04T18:37:17.557Z
Answers.LastActivityDate: 2019-10-04T18:37:17.557Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I see many stack exchange questions about views &amp; relationships but none like this.</p>
  
  <p>A person may attend many schools in his/her lifetime. </p>
  
  <p>Contact A "is a student at" Contact B (college, active relationship)</p>
  
  <p>Contact A "is a student at" Contact C (high school, expired relationship)</p>
  
  <p>Contact A "is a student at" Contact D (middle school, expired relationship)</p>
  
  <p>I need a view that displays all Organization names of schools where the contact type is "is a student at" whether active or not. </p>
  
  <p>This screen recording may better explain and shows my progress thus far: 
  <a href="https://drive.google.com/file/d/1_gkXbYn-Kdg8G-8JDfbz7J96ELvt_Gon/view?usp=sharing" rel="nofollow noreferrer">https://drive.google.com/file/d/1_gkXbYn-Kdg8G-8JDfbz7J96ELvt_Gon/view?usp=sharing</a></p>
  
Tags: <drupal-views><relationships>
Title: Drupal Views + Multiple CiviCRM relationships of same type
ThreadText: # Drupal Views + Multiple CiviCRM relationships of same type
  
  (Asked by: username_0 on 2019-10-03)
  
  I see many stack exchange questions about views & relationships but none like this.
  
  A person may attend many schools in his/her lifetime.
  
  Contact A "is a student at" Contact B (college, active relationship)
  
  Contact A "is a student at" Contact C (high school, expired relationship)
  
  Contact A "is a student at" Contact D (middle school, expired relationship)
  
  I need a view that displays all Organization names of schools where the contact type is "is a student at" whether active or not.
  
  This screen recording may better explain and shows my progress thus far:
  <https://drive.google.com/file/d/1_gkXbYn-Kdg8G-8JDfbz7J96ELvt_Gon/view?usp=sharing>
  
  **Tags:** drupal-views, relationships
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-10-04. Score: 2
  
  It appears the View you are using is starting from the entity CiviCRM Relationship. This is unusual in my experience. I would be building a View based on Contacts and then adding the Related Contacts by using the View Relationships to pull them in.
  
  
  ---
  
  