I have a View exposing a page with a class scheduler on it (http://nyhrc.resonetrics.com)
I'd like to display, either in a block or on the page itself, information about class instructors.
Classes are one content type, and instructors are another. Since my data is being imported via CSV using Feeds, there are no entity relationships between the two content types.
Each class has an Instructor ID assigned to it, to assign an instructor to that class; each Instructor has a unique ID number.
Users can select location, class type and instructor at runtime. These selections' values are clearly visible in the URL.
What i need to do is pick up the user's selection of instructor, pass that back to Views, and have it go fetch me the Instructor name, Photo, bio, etc.
So in SQL this would be something like 'SELECT name,image,description FROM instructor WHERE uid=instructor-id'
Firstly - can I do this with a block display? I understand bocks are more restricted w/r/t contextual filters.
If not - how can I filter the fields from the Instructor content type based on the user's selection in the exposed filters?
I can get the fields from Instructor to show up, I just can't figure out how to narrow down to the user's choice of instructor.
As always, all pointers appreciated.