Reporting on a project--12 fields
We want to create a report per team that tracks what work is assigned to each person. We have 12 fields on a resource tab that a person could be listed under. How can a report be set up to show ho...
Forum Discussion
Kari -
I would really suggest that you replace your 12 user fields with an 'Assigned Resource' table that would be a child to your CPO Projects table. This new table would have a User field for the Resource and a relationship to the CPO Projects table. You could add additional fields if you wanted to track more information, such as their Role in the project or other relevant info.
Moving to this structure would give you a lot more flexibility when it comes to assigning people to a project and then reporting on that.
------------------------------
Blake Harrison
Systems Analyst / Quickbase Developer
BCF Partners Capital
Houston TX
------------------------------