How to make a summary report from multiple tables?

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