This is a very specific issue with Views Relationships, I essentially want a table view incorporating 3 content types which are linked by an Entity Reference and field collection module. I'm having trouble setting up the relationships so I have drawn a mapped out picture of what it is - and how it should be:
The content types are "Curriculum", "Observation" and "Students". I can accomplish my table layout if I work from the Observation and include relationships, but I'm unsure how to connect the relationships to work backwards from Curriculum. The view should list all the Curriculum node titles (eg ELG 01 through to ELG 16) - this is why I need to work backwards from this content type and not just list ones that are set in the Observations.
An Observation will allow a user to tag a student (entity ref to Students content type) and it allows you to list a "Curriculum Area" and a "Curriculum Level" (these are grouped under the field collection field_curriculum_area_level.
If I was performing the views from an "Observation" perspective it would look like this:
But I need to start by listing all the Node Titles from the "Curriculum Areas" and then list the associated "Observations"
This is how the view looks (though the filter should work from "Curriculum" and not "Observation"
So to recap, I can get a list of "Observations" showing "Students" and "Curriculum" strands that are related, but I can't setup the relationships by starting with a view that starts with "Filter: Content Type: Curriculum Area" - I need to essentially setup relationships to work my way back from these "Curriculum" areas and show the Observation titles and Student Names -- if anyone has any ideas that'll be brilliant.