This thread supplies information on a method for doing an INVENTORY system using a single table for stock-in and stock-out transactions. Using a single table allows for easy queries for stock-on-hand and other figures related to stock and date ranges. I am going to cobble posts from other threads and attempt to make an argument for this design.