I'm building a knowledge base site for my company in Drupal 7.x.
The main content type is Report. There are three possible supporting content types, call them "A", "B", and "C".
A, B, and C each have a field called Related Report, which is a node reference to the title of one or more entries of the Report content type.
When a user selects an individual Report, there are three blocks on the sidebar. Each block lists related content of type A, B, and C.
What I want to do is use the Related Report value for A, B, and C to limit the list in each block to only content where the Related Report value is the same as the title of the Report content the user is looking at.
If I design the view with the Related Report field in the filter, I can select the title of any Related Report, but I need to do this dynamically based on the title of the Report the user is looking at.
Any ideas on how this can be done?