1. Go to Lists Manage Lists
  2. Select Manage Basic and Advanced Lists
  3. Select Add> Select Create Advanced List 
  4. On the Select Objects tab, add the following:
    1. Expand Constituent Information from the available fields >Select User Base 
    2. Expand Constituent Information from the available fields>Select User Role 
    3. From Constituent Information, select Parent/Child Relationships (Do this two more times so there should be 3 of these fields to account for if a teacher has at least 3 kids)
       
    4. From Constituent Information, Select User Base> Select the fParent/Child Relationship. User ID2 object from the drop-down menu> Select Select
    5. Select the User Base field again from the Constituent Information> Select the other  Parent/Child Relationship [1]. User ID2 that appears in the drop-down menu> Select Select
    6. Select User Base one last time > Select the last Parent/Child Relationship [2]. User ID2> Select  Select
       
    7. Unmark all of the checkboxes for Inner

     
     

  5. Select Display Fields >Mark Enable Grouping Options
     
  6. Select Select Fields to have the Select Display Fields box appear
    1. Expand User Base > Select First Name, Last Name, Email (This is the teachers)
    2. Expand Parent/Child Relationship > Expand User Base [1]> Select First Name, Last Name, Email, Student ID (This is the first kids)
    3. Expand Parent/Child Relationship [1]> Expand User Base [2]> Select First Name, Last Name, Email Student ID(This is the second kid)
    4. Expand Parent/Child Relationship [2]> Expand User Base [3]> Select First Name, Last Name, Email  Student ID (This is the third kid)  

      If you want to add other fields or rename the Display As field, you can.  Anything with a [1] would be the first child, [2] would be the 2nd child, [3] the third child, and no number would be the Teacher's info

     

  7. Select the Filters tab >Use the following Global Filters:
    1. In the first Global Filter drop-down, select User Role.Role 
    2. Select Teacher, press command on your MAC and select Nonteaching Staff 
       
    3.  In the Object Filters section , select Parent/Child Relationships.Rel Ordinal > Enter 1 > Select Select 
    4. Add a new row for the Object Filter section > select Parent/Child Relationship [1] .Rel Ordinal > Enter 2> Select Select 
    5. Add a new row for the Object Filters section >Select Parent/Child Relationship [2].Rel Ordinal > Enter 3 > Select Select 

     

  8. Select Preview
  9. Select Save