I have a taxonomy vocabulary called "Sports" that lists out a number of sports terms (Football, Tennis, etc).
I have one content type called "Team". I have a "Sports" taxonomy term reference field set as I associate a sport to the team. The field is called field_sport.
I have another content type called "Fixture". It has a node reference to "Team". The field is called field_sport_team.
- a Fixture has a Team.
- a Team has a related Sport.
How can I create a view with a contextual filter based on a "Sports" term that returns all related "Fixture" given that the "Sports" term is associated to a "Team" node reference?
Been stuck over the past few days...
Thank you for your help in advance!