I have a Person content type. It has a node reference field of a company which is also a content type. I then have a content type called Project. A project has a node reference to a company content type. I want to list all the projects related to a person id (nid)
If I abstract this away from views and Drupal and each content type had it's own table I would use something like.
Select ProjectName from Projects where CompanyID IN (select CompanyID from Perons where PersonID = 10)
Can I do something similar in Views?
My PersonID would be an argument. This would bring back the person content type. I would then use a relationship to bring back the company.
I now don't know know how to link the company up to the project...