I have 2 content types (project and issue), you can think of this as an OG style set up, the child nodes reference the parent node via a node reference field called "project" on the issue node type.
The "project" node type has a user reference field called "members".
I'm trying to build a view to create a user reference field on "issue" called "assignee", I would like to limit the users that may be referenced to the users who are in the "members" field of the project node.
So I've created a user view with a reference type and am playing with adding contextual relationships and references, but I am getting no results. I know this is a pretty complex way to use these modules, and typically I would just write a module to achieve this, but I would really like to do this without writing a new module.
Has anyone ever dealt with anything like this?