Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Thu Mar 29 13:33:18 CDT 2007
Yeah that would work. You could combine removed and added in tbl_Storage (which is your transaction history table?). A negative quantity would indicate removed, positive, added. Do you need to be able to move inventory between locations? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia Sent: Thursday, March 29, 2007 11:15 AM 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 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.20/737 - Release Date: 3/28/2007 4:23 PM