Currently I have 3 content types: Program, Chapter, Item. The program content type has a node reference field to contain multiple chapters and the chapters content type has a node reference to contain multiple items.
I now have a view that lists some items, but I also want to pull in the program title that is referencing that item.
Program = Fruit Chapter = Pear Item = Cutting a Pear
I want to list the title of "Cutting a pear" and also the program "fruit" title.
In my view for my items I tried creating a relationship to tie in the "program", but the only relationship that I can use is the "Chapter" because I guess its directly related to the item. The program is not tied to it in any way.
Any ideas how I can pull in the program title information when its not directly related to the item?