That seems really difficult. this is supposed to be an epos system that can be used in a pub so there are going to be vast amounts of sales going through on a daily basis. I have an admin form which has restocking buttons which add to the stock on another database which I can bring across from another database.
The problem is that there can be a large number of Items in the current sales table. There can also be numbers of the same item (3 Carling for example)
I don't really have enough experience in this area.
I have tried to use
Code:
SQLStock = "UPDATE TblDraughtStock t INNER JOIN tblCurrentSale c ON c.DraughtID = 1 SET t.Stock = t.Stock - 1 WHERE t.DraughtStockID = 1"
but this did not work, and I would have to make the SQL statement 12 times as long to include "IF" for each of the drinks
would someone be able to help me do a stock check for my on hand. it think this could be much more interesting as long as I can get reports for it. I'll upload my project now and if I could be pointed in the right direction I would be most grateful. I just couldn't see how to make it work from what was shown on the link.
Thanks
Sam