Susan Harkins
ssharkins at setel.com
Thu Mar 29 09:23:11 CDT 2007
It's a big job, no matter who does it -- so Virginia don't feel bad. First, consider whether you need to maintain a history of activity -- who took what, when, why, and even how might be appropriate. How many people or transactions are involved in one item? You'll be amazed. :) Decide that before you actually start developing. Susan H. IIWM, I would set up an "item" table, a location table, and an ItemLocation table. The item table would simply list the items that can be in inventory, the location table would list possible locations that items could be, then the ItemLocation table would list what item was in what location. That is the basics. Inventory counts would then consists of counts of the InventoryLocation table. You could get counts by location (how many "things" are at a location), counts by item (how many items exist somewhere), and counts by itemlocation (How many items are at a specific location). Then take it from there - date added to location, date drawn from location etc. I have never done an inventory module either BTW so take that with a grain of salt. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia Sent: Thursday, March 29, 2007 7: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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.20/736 - Release Date: 3/27/2007 4:38 PM