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?