[AccessD] Inventory Tracking

Have a look at this explains stock taking and quantity onhand
http://www.allenbrowne.com/AppInventory.html

Hollis, Virginia wrote:

>They only need to track what is in a location. Don't need cost, vendor
>info, or anything like that.
>
> 
>
>It is like this:
>
>I have a blue box and a green box. Each box has pens & pencils.
>
>I have 35 pens in a blue box; I used 10 pens today from the blue box,
>now there are 25 pens in the blue box.
>
>Tomorrow I take out 5 more pens, now there are 30 pens in the blue box.
>
>In the same blue box I have 15 pencils. Today I take out 5 pencils from
>the blue box, that leaves me 10 pencils.
>
>Extra for adding pens to the blue box.
>
> 
>
>Then I have the same type of pens in a green box......
>
> 
>
>Let me know if this would be correct:
>
> 
>
>tbl_Storage
>
>StorageID
>
>StorageLocation
>
>TypeID
>
>ActualInv
>
>MinimumInv
>
> 
>
> 
>
>tbl_Type
>
>TypeID
>
>Type
>
> 
>
>tbl_StorageType (or some name like that)
>
>StorageTypeID
>
>StorageID
>
>RemovedInv
>
>AddedInv
>
>DateTransaction
>
>Comments
>
> 
>
>Virginia
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada