Product Purchase to Shipments Solution
I am quite familiar with FM but there are just some things I have never gotten into or understood. This is probably very simple to do. I buy products from local discount stores, flee markets, etc and ship crates to countries outside the US. The same products over and over again so I have created a products table with item #, description, weight. I have another table that is purchases with a date of purchase field, item #, description, and purchase price. when I buy something, for convenience when I enter the item it looks up and populates here I want to be able to create shipments or orders from my purchases. so with each shipment I can track ship date, total qty shipped, total shipping, etc. Any thoughts?