I wanna create the following relationship view:
I have a content type "Company" which has many user reference field to. Then I hace a content type "Invoices" which hase node reference to node type "company". My goal is to add Invoices to "Company" so every user related to his company can see the invoices (invoices are files attached to the invoice node with filefield)
I am using views 2 with D6. I managed to get all the Invoices displayed but I wanna display only those Invoices to the user which belongs to his company.
Can anyone give me an advice how to achieve this?