Forum Discussion

BenBen1's avatar
BenBen1
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...
Relationships
reports and charts
Tables and fields
NealNeal's avatar
NealNeal
Qrew Member
9 years ago
Hi Ben,

Please let me know if the following data represents the data in your question.



Projects Table
----------------------
Project1
Project2

Tasks Table
Task Project         Assembly
--------------------------------------
Task1 Project1 Assembly1
Task2 Project1 Assembly2

Assemblies Table
--------------------
Assembly1
Assembly2

Items Table
Item   Assembly
-----------------
Item1   Assembly1
Item2   Assembly1
Item3   Assembly2
Item4   Assembly2


Find Items required for Project1
-------------------------------------
Item1
Item2
Item3
Item4




Thanks,

Neal


NealPatil @ gmx.com