I'm having difficulty with setting up a view in Drupal 7. I'm going to use a sports example as a way to illustrate my problem:
I have three content types: 1. Team 2. Roster 3. Player
On the ROSTER editing page, I select which TEAM this roster belongs to, via Entity Reference.
On the PLAYER editing page, I select which TEAM this player belongs to, via the SAME entity reference field.
I've created a view, specifically a block, that lists the players on the roster page. However, right now, it's displaying ALL players. I know this is what contextual filters/relationships are for.
However, I get lost in the contextual filter and relationship settings. I've read a lot of documentation about each, impressed by all the different explanations and demos, but can't seem to find the right configuration that works for my problem.
I'm trying to filter the players on the ROSTER page, based on the TEAM that is selected both in the ROSTER and PLAYER content types.
Any help, suggestions, advice is appreciated. Thank you.