Maybe I'm missing something obvious or thinking about it all wrong, or maybe the functionality doesn't exist and I'll have to do something different, but I'm trying to create a view that has links to another view thats list is filled from and argument of some type.
I have two custom content types: a sermon and a series of related sermons. What I want is to have three listings (via Views): 1) a list of the X most recent sermons, 2) a list of all the series, and 3) a list of sermons within a specified series. Also, I want to be able to click on the series name in Views listing 1 and 2 and have it bring up the related listing 3. I have 1 and 2 done easily enough, but I'm having a bit of difficulty coming up with an acceptable solution for 3.
What I have thought of and/or tried so far: I have in the sermon's content type a node reference field to the series it belongs to. However, that field is unavailable in the Views UI. I have tried using arguments and specifying a view as the target, but that's not even an option from with Views. I have tried taxonomy, but the user input is not as clean as I would like for potential computer neophyte and/or illiterate users.
Is what I'm trying to accomplish possible? If so, how?
What I'm looking at doing short term is creating individual views for each series, but that is really not what I want to be doing long term, nor do I want to have that as part of the process for a new person to learn.
Thanks for your time and feedback.