I have a content type called "orders" and another called "pickups". When I create a new "pickup", I pick which order its associated with it. But when I view my orders I have no way to "reverse" reference this to see which orders have been picked up. I would imagine a reverse entity reference would solve my issue but I can't figure out.
I want to show this information in a view table that displays all my "orders" and on each row show the ones that have a "pickup".
How can I achieve this?