Please see this thread in regards to the tables etc I've got so far: (I cant link yet) Theory and Practice - "Database Dummy - design help?"
According to plog's suggestion, I've written a query on my tbl_transactions to calculate the current stock field. I'm not sure that I've done my...