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.

 

How?

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: https://community.filemaker.com/message/167647?sr=search&searchId=40cea5bd-9a85-4c9c-b244-fa5b5c1f0e8e&searchIndex=1#167647

and

https://community.filemaker.com/message/225831?sr=search&searchId=81dfa585-0c04-442a-bbf4-069c108e62a9&searchIndex=5#225831

 

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

Outcomes