1. Navigate to Lists > Manage Lists
  2. Click the Manage basic and advanced lists block under List Actions
  3. Click Add > Create Advanced List
  4. Under Select Objects, select the following objects:
    1. Constituent Information > User Address
    2. Constituent Information > User Base
    3. Constituent Information > Parent/Child Relationship
    4. Constituent Information > User Base
    5. Constituent Information > User Role
    6. Constituent Information > Parent/Child Relationship
      • Select User Base.User ID as the Parent
      • Unmark the Inner checkbox
    7. Constituent Information > User Base
      • Select the new Parent/Child relationship as the Parent
      • Unmark the Inner checkbox
    8. Repeat steps 6 and 7 as needed
  5. Select the Display Fields tab
  6. Click Select Fields
  7. Mark which fields to display
  8. Click Select
  9. Mark Enable Grouping Options
  10. Select the Filters tab:
  11. Add the following Global filters:
    1. User Role.Role any of Student
  12. Add the following Object Filter(s):
    1. Parent/Child Relationship.Rel Ordinal equal to 1
    2. Parent/Child Relationship [1].Rel Ordinal equal to 2
    3. Repeat in this fashion as needed until all Parent/Child Relationships have been included
  13. Name the List and select a Category (if needed)
  14. Click Save
  15. Click Preview