Forum Discussion
QuickBaseCoachD
Qrew Captain
I miss spoke aboveThis is what I meant to say.
I suggest that you fact make a Report Link of of Project Members on your companies table by looking up the field probably called [Related Compny] in Contacts down to the Project members table and called it what it is which is [Record ID# of Company]
So on the configuration for the report link field on your company�s table the left side will be record ID and the right side will be a record idea of company located on the project members table.
I suggest that you fact make a Report Link of of Project Members on your companies table by looking up the field probably called [Related Compny] in Contacts down to the Project members table and called it what it is which is [Record ID# of Company]
So on the configuration for the report link field on your company�s table the left side will be record ID and the right side will be a record idea of company located on the project members table.
IvanWeiss
5 years agoQrew Captain
Okay, getting there! Thanks as always for your help. I actually did this but forgot it would be under Project Members - Contacts - Related Company. So I did have that right as you said :)
I changed the report as appropriate and now we are getting the list of projects....
One last thing though, on a few of them I have multiple project members from the same company on the same project. So how do I only show the project once? For example on my Anthem project I have (3) people from Compass Group (company) s it is showing the Anthem project (3) times.
I changed the report as appropriate and now we are getting the list of projects....
One last thing though, on a few of them I have multiple project members from the same company on the same project. So how do I only show the project once? For example on my Anthem project I have (3) people from Compass Group (company) s it is showing the Anthem project (3) times.