Forum Discussion

QuentinFleischf's avatar
QuentinFleischf
Qrew Cadet
5 years ago

Resource Summary Timeline

I have 3 tables Programs Tasks Resources A Task is assigned to a Program and a Resource is assigned to a Task. I have managed to establish table relationships between the tables so I can repo...
Forms
Relationships
reports and charts
DebbieTaylor's avatar
DebbieTaylor
Qrew Trainee
5 years ago
Hi, Quentin -

Give this a try

  1. Create a new table called PTR (Projects-Tasks- Resources)
  2. Create 3 one to many relationship.  One project to many PTRs; one task to many PTRs; one resource to many PTRs.  When you do this, Quick Base will automatically create a report link in the Programs table called 'PTRs'.
  3. Add fields to the PTR table including: start date, end date, allocated hours, actual hours
  4. Create records in the PTR table for each person assigned a task on a project
  5. (Re) build the report you want in the PTR table
  6. Put the 'PTRs' report link field on the form in the Programs table.
We're at CloudBase Services if you want help.