Creating a summary report from related tables

[davidAtayde]

Hi,

I'm developing an app that allows users to generate a material list (ComboKit) composed of one or more kits, and each kit contains one or more materials.

I've managed to define the tables and their relationships. I want to create a bot that, when a button is pressed in the ComboKits view, generates a PDF, Doc, or Spreadsheet with the total material list, summing the quantities of identical materials that are part of different kits.

I'm unsure how to generate the total material list from the ComboKit table.

These are the tables:

1. Vehicles
   
   
2. Materials
   
   
3. Kits
   
   
   
   
4. Kits_Details
   
   
   
   
5. ComboKit
   
   
   
   
6. ComboKit_Details
   
   
   
   
   Expected outcome example:
   
   
   
   APP