[AccessD] Inventory Tracking

Hi Virginia:

Check out this site: http://www.databaseanswers.org/data_models/index.htm
There is a link to it off the Miscellaneous Reference List from the DBA
site.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Thursday, March 29, 2007 4:37 AM
To: accessD at databaseadvisors.com
Subject: [AccessD] Inventory Tracking

Does anyone have anything that would help me set up a new database for
tracking inventory? I can't seem to get it in my head how to set it up.
It should be simple, but adding to the inventory & taking out of
inventory - I am having problems with setting up the tables. This is my
first inventory tracking system.

 

There are only 3 storage locations where the inventory is kept & only 5
types of items stored. But adding and removing items, then keeping track
of the minimum inventory and the actual inventory I don't know the best
way to set up the tables.

 

I know I need a location table & a type of inventory table, but how do I
list the same items for each of the 3 locations in a table? If they add
to the inventory at a certain location on a certain date, it should add
to the actual inventory for that item and location.

 

Hope someone can help on this....

 

Virginia

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com