Drupal views get field info from node within another field 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.
I assume that you are using the References module to provide a Node Reference field to Photo Gallery nodes which reference Projects, and then provide another Node Reference field, or Term Reference field to Project nodes which reference Categories?

In Views:


Expand the Advanced column
Add a Relationship
In the Add Relationships dialog, select the Photo Gallery: Project Node Reference field from the list
In the Configure Relationship dialog, Click Apply
Add another Relationship
This time in the Add Relationships dialog, select the Project: Category Node/Term Reference field from the list.
In the Configure Relationship dialog, there is a field labelled Relationship with a drop-down menu, which lets you choose other compatible relationships you've added previously, from which you should select the Photo Gallery: Project relationship (I'm not entirely certain what text to expect here). Then click Apply.
Now when you add new Fields to the View, you'll have the option to select a Relationship for each individual field, which allows you to pull data from the entity (Node/Term) that is referenced by the selected Relationship