Forum Discussion

Qrew Trainee

9 years ago

How to make a summary report from multiple tables?

I have four tables. A Project table, a Task table, an Assembly table and an Item table. Each record in the Project table has many related tasks. Each record in the Task table has a numeric field d...

Qrew Captain

9 years ago

I'm 99% sure this can be done natively, but I want to understand your relationships.

Is this the setup

Project < Tasks > Standard Assemblies < Item Assembly Assignments > Item Masters

1 Project has Many Tasks
1 Standard Assembly has Many Tasks
1 Standard Assembly has Many Item Assembly Assignments.
1 Item master has many Item Assemby Assignments.