AnsweredAssumed Answered

Help for building "Order & Inventory" database

Question asked by leonhart1981_1 on Nov 23, 2017
Latest reply on Nov 24, 2017 by DanielShanahan

I am planning to build a database that will help me track my order status and inventory


Below image is the structure draft:


FileMaker order structure idea .jpg


My idea is to have a Proforma Invoice received from my supplier; then received it based on the Proforma Invoice. Can anyone confirm if my structure is correct?


However, I don't have a clue how to put the received item qty back to my inventory? Can anyone give me an advice?