The DB is structured with 13 different tables, the first 12 are each representing of a section of the inventory, the 13th should be the total report from all sections plus the sum of them:
Layout1 (Product1 Inventory)
Field-A1 Product1 Name
Field-B1 Quantity
Field-C1 Price
Field-D1 Product Value (Quantity x Price)
Field-E1 Total Product1 Value (Sum of Product Value)
Layout2 (Product2 Inventory)
Field-A2 Product2 Name
Field-B2 Quantity
Field-C2 Price
Field-D2 Product Value (Quantity x Price)
Field-E2 Total Product Value (Sum of Product Value)
Layout3 (Product 3 Inventory)
Field-A3 Product3 Name
Field-B3 Quantity
Field-C3 Price
Field-D3 Product Value (Quantity x Price)
Field-E Total Product Value (Sum of Product Value)
Layout4 (General Report)
Field X = Field-E1 Total Product1 Value (Sum of Product Value)
Field Y = Field-E2 Total Product2 Value (Sum of Product Value)
Field Z = Field-E3 Total Product3 Value (Sum of Product Value)
Field K = Sum of Field X + Field Y + Field Z
Note: Fields A,B,C,D are fields with repetitions, Field E is a single calculation field. Also, the whole thing is based on a SINGLE record for each table.
---
What I cannot achieve is, on layout 4 to properly read the Fields E1,E2,E3 and bring them into Field X,Y,Z in order to make the calculation implied in Field K. Also, I would need Field X,Y,Z to selfupdate the numbers WHEN something changes in Field E1,E2,E3.