Creating Relationships in Views 2
rgraves - May 27, 2009 - 15:50
I'm trying to figure out how to build a relationship between two content types using Views 2.
I have 2 nodes. One is the parent node and the other is the child. When creating the child node, the user selects the parent node from a select box (field_resource).
I want to create a view that lists all the fields of the parent and child together. I did this in Views 1, using views fusion, by creating 2 views (parent view = 'resources', child view = 'articles') and then fused them together like this:
primary view: articles
fused view: resources
using: Node Reference: Resource (field_resource)
I can't figure out how to accomplish this using relationships in Views 2.

I figured it out. I added
I figured it out. I added the relationship and then clicked on the field that's part of the other view. I didn't see the relationship drop down at the top of the field properties.
Here's a Tutorial that will benefit Searcher that find this post
Congratulations on helping yourself to the solution ;-)
I'm posting this tutorial with the desire that it will save time for the other folks coming after that are faced with the same challenge. I wasted a lot of time searching until I found Matt's video.
http://gotdrupal.com/videos/drupal-views-relationships
Thanks to Matt Petrowsky over at GotDrupal.com
Derek G
Derek G
DGTLife, LLC
Drupaling since 2008