Forum Discussion

JasonPhenicie's avatar
JasonPhenicie
Qrew Trainee
8 years ago

Creating a summary report based on multiple columns

In our project management app, each team member can be assigned to a project as team 1 lead, team 2 lead, team 3 lead or additional team. I need to create a summary report that shows each team member ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
I think that you would need to set up a Parent table of Users with the Key field Userid and make relationships instead if the plain user field. That would cover the first 3 positions.

For the last position where you can assign multiple resources, this would need to be done with a child table of resource assignments.

1 Resource has Many Resource Assignments.
1 Project has Many Resource Assignments.

So I think that you would need to make those structural changes to the app to get that that summary. You have to decide if the �Juice is worth the squeeze�.