How do I pull totals from a table to another field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have seperate tables for Material Costs, Labor costs, and Commissions. They are all related to the Projects table, so that each project has 3 seperate itemized reports listing all of the Material costs, Labor costs, and commissions. At the bottom of the report it has a TOTAL, adding up each reports items. 

I'm wanting to pull these totals to fields in another area of projects. Basically I'm trying to do job costing. So I have fields labeled "Total Commissions", "total Labor costs", and "Total Material Costs". How do I pull the total amounts from each report into the fields I created?

Photo of Jennifer

Jennifer

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
If 1 Project has Many Material Costs in a Relationship, then edit that relationship and on the left hand side there will be a button to Create a Summary field. Just make a Summary field of the Total Material Costs.  Then repeat for the other two tables.