Hello everybody.
I would like to show in my FERTILIZATION PLANS parents table the list of products inserted in the grandchild INTERVENTION ROWS table, with the sum of the relative quantities / product price / total price per product (products can repeat in the grandchild table)
Something like:
PRODUCT 1 10 kg 3.00 โฌ total 30.00 โฌ
PRODUCT 2 5 kg 2.00 โฌ total 10.00 โฌ
PRODUCT 3 1 kg 7.00 โฌ total 7.00 โฌ
.......
What is the best approach to achieve this in the parent table?
LinkedIn
Twitter
