Forum Discussion
JeffRichey
Qrew Trainee
Hi Ivan,
In order to achieve your desired result, you have to pass the Project ID to your Companies table which will allow you to create a report link as described in this post.
https://community.quickbase.com/quickbase/topics/lookup-from-a-lookup
In order to achieve your desired result, you have to pass the Project ID to your Companies table which will allow you to create a report link as described in this post.
https://community.quickbase.com/quickbase/topics/lookup-from-a-lookup
IvanWeiss
5 years agoQrew Captain
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.
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.