FULL JOIN

MarkShnier__You
Qrew Legend
4 years ago
Can you explain how you would match up these records manually? How do you know which Table 1 Record match to Table2

Maybe you can give an example of the data so I can understand the matching you were looking for.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- AndrewS
  Qrew Trainee
  4 years ago
  Sure,
  
  Table Estimates has fields Product, Estimate Amount, Category (look up field from Category table)
  Table Purchase Orders has fields Product, PO Amount, Category (look up field from Category table)
  Table Categories has a field Category, and it is a Parent table for Estimates and Purchase Orders tables.
  
  I would like to have the Summary reports and the Chart reports, which will combine data from two and more tables, like
  
  Category 1 | sum of Estimate Amount | sum of PO Amount
  Category 2 | sum of Estimate Amount | sum of PO Amount
  .....
  Category n | sum of Estimate Amount | sum of PO Amount
  
  ------------------------------
  Andrew S
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    4 years ago
    I think that all you need to do is to go to the relationship where One Category has Many Estimates and Create a Summary field there to total the Estimate value.
    
    The do the same on the other Relationship to Total the PO Amount.
    
    Then just add those two fields to the regular table report of Categories.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion