Exporting Parent Records and Showing Child Majors

Options
Hello.  Is there a way to pull a list of parents and show what their children's majors were?  This one is stumping me, and I'm beginning to wonder if the only way to do this would be to code 'child's major' as an attribute on the parent record.  I was hoping that wouldn't be necessary, but I can't see how else to do it.  Thank you!

Comments

  • You can pull the data pretty easily using relationships.  I pull the constituent record and then go into relationships and select "Child" or however you have them coded. Under the Relationship node, I pulled Primary Alumni information, but you can probably use the Education node as well.  So its, Relationships, Individuals, Primary Alumni information, Majors, Major.  Of course you have to put in the criteria as you go.

Categories