Forum Discussion
JeffRichey
5 years agoQrew 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
- IvanWeiss5 years agoQrew CaptainSo I think I am following it but will that allow numerous Project ID's? So I create a project ID reference proxy in the Companies table? But each Company might have multiple projects associated with it?
- QuickBaseCoachD5 years agoQrew CaptainIvan,
You are overthinking this. It�s easy.
Report link fields just love to run reports. They just need two values to match on.
So just coax the Record ID# of the Company down to any child table in your app, or grand child, or great grand child.
Then on the Company table create a Report Link field and on the left field in field Properties Select the Record ID# of the project and then on the right side of the configuration in field properties navigate to your app and the target table and locate the Record ID# of the project to match on.
Then just put that report link field on your form and set the form properties to display the children directly on the form and probably build a report to use for that purpose. Sent the form to use that report. - IvanWeiss5 years agoQrew CaptainSo 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. - QuickBaseCoachD5 years agoQrew CaptainI do not see any relationship diagram posted here. Can you tell me the relationship between companies and contacts and projects? Is Project simply a grand child of companies?
- IvanWeiss5 years agoQrew CaptainJust posted the relationship diagram. I think the challenge I am having is how to get past the project members table. That is where I lose the ability to connect the data.
A contact can be associated with multiple projects.
A project can be associated with many contacts.
So I have a join table called Project Members.
I believe that is where I am losing the ability to pass the data through.