I have a problem and here's my graphical illustration of it:

I have tried many things that didn't work. I think the answer has something to do with adding a relationship with a node field, but I don't know how to get it to work here.