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...