setting up complex consumables inventory and linking it to purchase orders
We have one database called "CONSUMABLES" started from the " INVENTORY" starter solution template within Filemaker 11. We would like to maintain an inventory of all of our regularly depleting resources in three distinct categories. INK, BULBS, and CHEMISTRY with a fourth category reserved for PURCHASE ORDERS for reorders of the aforementioned categories.
We would like to have an inventory summary report for each category.
For example: At the end of Sunday (when our inventory gets done) we want a summary report that tells us:
Each item, number to reorder, and the associated calculated fields to give us total cost for each item. Then we want to create a purchase order out of this information using drop down options (like vendor) that will pull associated information (like shipping address/payment information/etc)
Also, we will be using FM Touch plugin/app for the iPad so our workers can enter in stock amounts in various rooms via the iPad.
Is it correct to create four separate layouts within the consumables inventory database? Three layouts for inventory and one layout for purchase orders? Should I have a primary general inventory called CONSUMABLES for the import of records, then three separate layouts for individual categories?
Should I just use tabs within one layout? and then do a sort within the inventory summary report?
What is the best way to alter the existing Inventory.fp7 template in File Maker Pro 11 to achieve what I'm trying to do?