Drew Wutka
DWUTKA at Marlow.com
Fri Mar 30 10:56:36 CDT 2007
Stay away from recording inventory levels in a field. Use a transaction table instead. Ie: tblTransactions: ItemID TimeStamp LocationID TransactionValue Example values: 1, (some date),1,50 1,(some date),1,-25 To find out how many item 1's you have in location 1, you would sum the Transaction value, giving you 25. I have a sample I handed out offline, which is probably too complex for what you need, but you can take a look if you'd like: http://www.marlow.com/CapformInventoryFE.zip Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia Sent: Thursday, March 29, 2007 1:15 PM To: accessd at databaseadvisors.com Subject: [AccessD] Inventory Tracking 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com