I have looking around and found several good solutions. But I can't realize them to my problem.
First, I have 3 tables; Order, OrderProduct and Product.
In order I work with the order preparation and I want to track the inventory of the material I use in production. (like paper and Ink) They are not all measure in quantity but also in weight.
I have tried to make a portal in Order and show OrderProduct. But all my material is in Product table.
I think I'm stuck in thinking...
They all seems very competent, but for me, I'm having a hard time translate it to my type of use.
Should I change my tables for making this work?