AnsweredAssumed Answered

Tracking inventory confusion

Question asked by andresen on Jun 1, 2016
Latest reply on Jun 1, 2016 by DanielShanahan

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...

I have taking a look at:



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?

Relation 2.tiff