Answers.Body: <p>If you just need a list (i.e. not to send mails), and are based upon Drupal, you can also use Drupal Views (> advanced > Relationships).</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-20T06:29:44.920Z
Answers.LastActivityDate: 2017-07-20T06:29:44.920Z
Answers.UserDisplayName: Jacques-Marie Moranne
Answers.Body: <p>You can explore <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow noreferrer">Extended Reports</a> extension that allows extend related Relationship Reports with details of both parts of the relationship.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-18T18:46:55.867Z
Answers.Text: Can You use Extended Report to send mails or mailings ?
Answers.UserDisplayName: Jacques-Marie Moranne
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-18T22:34:09.967Z
Answers.Text: No. I think Extended Reports have the same actions as core Reports.
Answers.UserDisplayName: Francesc Bassas i Bullich
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-16T20:18:00.247Z
Answers.LastActivityDate: 2017-07-16T20:18:00.247Z
Answers.UserDisplayName: Francesc Bassas i Bullich
Answers.Body: <p>Yes, using Advanced Search (<strong>Search menu » Advanced Search</strong>).  Set up the search the same way you would in order to find the children.  Additionally, set the "Display Results As" at the top to "Related Contacts", and select the "Parent of" relationship.</p>
  
  <p><a href="https://i.sstatic.net/VdeXm.png" rel="noreferrer"><img src="https://i.sstatic.net/VdeXm.png" alt="Advanced Search - display results as"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-16T19:39:30.940Z
Answers.LastActivityDate: 2017-07-16T19:39:30.940Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>Is there a way to query the Custom Fields on a Child and then show their Parent's detials? Scenario: email all parents whose children attend a certain class.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-17T16:12:29.157Z
Comments.Text: Are you using relationships to connect Parents to their children? First thoughts here would be to use smart groups for each class.
Comments.UserDisplayName: jackrabbithanna
Tags: <custom-fields><search>
Title: List Parents of Children having certain values
ThreadText: # List Parents of Children having certain values
  
  (Asked by: username_0 on 2017-07-16)
  
  Is there a way to query the Custom Fields on a Child and then show their Parent's detials? Scenario: email all parents whose children attend a certain class.
  
  **Tags:** custom-fields, search
  
  > **Comments:**
  > **username_1**: Are you using relationships to connect Parents to their children? First thoughts here would be to use smart groups for each class.  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_4 on 2017-07-16. Score: 7 | Accepted answer
  
  Yes, using Advanced Search (**Search menu » Advanced Search**). Set up the search the same way you would in order to find the children. Additionally, set the "Display Results As" at the top to "Related Contacts", and select the "Parent of" relationship.
  
  [![Advanced Search - display results as](https://i.sstatic.net/VdeXm.png)](https://i.sstatic.net/VdeXm.png)
  
  
  ---
  
  ### Answer by username_2 on 2017-07-20. Score: 0
  
  If you just need a list (i.e. not to send mails), and are based upon Drupal, you can also use Drupal Views (> advanced > Relationships).
  
  
  ---
  
  ### Answer by username_3 on 2017-07-16. Score: 0
  
  You can explore [Extended Reports](https://civicrm.org/extensions/extended-reports) extension that allows extend related Relationship Reports with details of both parts of the relationship.
  
  > **Comments:**
  > **username_2**: Can You use Extended Report to send mails or mailings ?  
  > **username_3**: No. I think Extended Reports have the same actions as core Reports.  
  
  ---
  
  