Drupal views relationships to an indirect referenced contenttype I want to create a view with a field which shows an indirect referenced contenttype (see Design) using Drupal 6.

I have 3 content types: Person, Organization and Workgroup.

Each person is related to only one organization by the node reference field: field_related_org_unit.
Multiple persons can be linked to the same organization.

Each workgroup is related to only one organisation by the node reference field: field_supported_org. Multiple organizations can have the same workgroup.

Now I want a view which displays the information of a certain person (firstname, lastname) and in the same view I wan to show the workgroup which he is indirect related to (sharing the same organization).

So say, Person A is related to organization XYZ.
Workgroup B is related to organization XYX.
I want to show the title of Workgroup in the view.

I tried several relationships in the View, but couldn't get it working.
 see Setup View

Is it possible to realize this kind of setup? Could someone help me out?
The node reference fields in both the person and the workgroup both point to the same organization. Set up a relationship between person and workgroup on the organization field. That should make the workgroup name available to the view.