I'm attempting to create a view which will show Photo Galleries that have a reference to a project. The project has a reference to a category. It is on the category page I want to show these galleries.
So I am on the category page, and would like to show the latest galleries posted within the projects in this category.
When creating the view for photo galleries I can display the project field, so I know what project they are in. However the category field is within the project node, so how can I find out what category the project has referenced?
I need to look at the node referenced in the project field, then take the category field from that to determine if it is associated to the current category. Is this possible within the fields module or should I look at something else?
Hopefully this question makes sense, if not please ask questions or edit the question. Thanks!
Edit: This is using Drupal 7 and I assume views 3.