In its simplest version, my database has three main tables (production, product, distribution) and two secondary (join_production-product and join_product-distribution).
the problem is in the format "distribution" where two portals are: the first based on "join_product-distribution" that allows me to enter the amount of pieces (classified by flavor) that I delivered to the place during time. This works perfectly.
I would the second one to show the single flavors that a place owns and the delivered total.
On which table I have to base my portal?
I tried to base it on "product" and currently works reporting only the names of the tastes present in a place, but I'm interested also in how much flavor have been delivered.
I attached my file.