Recent content by probingreality

Hi I am trying to build a simple database for tracking inventory in a kindergarten. Basically, the prinicipal wants to be able to: 1. Input ordered products and their amount 2. input which employee takes a product, number of products taken 3. Stock control - how many products are left...

Thanks plog, I was thinking of creating another table that could take the information from Inventory Transaction table and ProductPurchasing table but I was not sure if this was the way to go. I am still not sure how exactly it will happen

Hi I am trying to build a simple database for tracking inventory in a kindergarten. Basically, the prinicipal wants to be able to: 1. Input ordered products and their amount 2. input which employee takes a product, number of products taken 3. Stock control - how many products are left...