So just to create a bit more clarity as I have been playing with this.... I created the report link field. What I am unsure is what field to map it to. I have Record ID for Companies on the left side, on the right side though how do I establish where the match projects are? I tried Project Number (which is a ref ID field) but that just returns the project with the matching ID. I need to return all of the ID's for projects containing this company. I thought maybe that somehow comes from the Project Members table I have.
Project members which is a join table in essence between contacts and projects and each contact belongs to a company.
But in short, I cannot figure out how to get the matching projects to this specific company.
