I need to also track who bought what, how much and the price they payed.
To recap: I'm buying the same items at different prices and quantities, I need to track how much of it I have, and I need to track the sales.
My Initial thought for table design was:
Stock StockID, item type, item name, bought price, bought quantity, selling price, isSold, (This is just to mark it so I can leave it out of db queries)
SaleID, Customer, StockID(F-Key), amount, isDelivered,
Can someone give me some insight on this, I'm sure there is a way to improve it. If you need more information, please let me know />
This post has been edited by Handler: 03 February 2013 - 04:08 PM