Tracking amount used in different products


I’m trying to track material use among different products. Each material has a unique identifier as well as each product. Materials can be used in more than one product. I’ve figured out how to log what material I have used in each product, but not how much of each material. I would also love to be able to track total of each type of material used. Any suggestions how to set this up?


1 table for Products, one table for Materials, and joining table for Usages. Check this:

In the last table you will can Group By materials or products.