Inventory/Purchases solution

[winerchip]

I am relatively new to FM Go, but I have created a few rather simple databases that I use regularly. I have one database that tracks quantities of stock and I use it to determine a reorder level from regular on-hand counts. I am having some mind fatigue in determining how to track purchases for these items.

I am not very agile with Relationships, and I suspect this is involved with the ultimate answer. Any suggestions would be appreciated.

[Fitch]

The question isn't really about FM Go. See if this helps:

http://fmforums.com/forum/topic/84644-making-database-for-inventory-control/