Skip to main content
Question

Create Inventory System Help

  • September 30, 2022
  • 0 replies
  • 51 views

Good morning, I'm looking to create an inventory system that we can track. I am wanting to have a table with all are inventory items about 30 items total that we will be updated manually as we restock inventory. But I am also wanting another table that can link back to it that employees can use to create an inventory pull form showing the item they took and how many and then remove that number from the main inventory table, so we know what we have in stock at all times. Im looking for some suggestions and help on how this can be done with linking them to show updated numbers as we pull items.



------------------------------
Matthew Jones
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+15
    • DonLarson
    • Qrew Cadet
    • October 19, 2022
    Matt,

    Here is an architecture that will work.    The RHS assumes that you are pulling inventory for Projects that have a Bill of Material.   That is where you build your Pull form to take to the Crib for release of Inventory items.

    It also assumes that Items in Inventory can be acquired from multiple Vendors.




    ------------------------------
    Don Larson
    ------------------------------
    Terms & ConditionsAccessibility statement