I have started making a stock control database, i have spent about a week on it, And i am struggling! There are obviously lots of different ways to actually build them efficiently. My problem is that i want to add stock and take stock out, changing the stock quantity and obviously keeping track of stock. I only want to ammend the stock quantity, in the stock table if the item is not a new item. The stock is added via a log sheet which could also have a new item. My head is beginning to hurt, but with a bit of help from you guys i might be able to crack it.
The Tables I have are:
tblStock
tblCategories
tblSuppliers
tblInventory transaction
tblStock_in
tblStock_Out
tblEmployees
Is this sufficient? Can i add stock and take stock out with one transaction table? Or would i need to add another table? I believe the code would be through a query but again am a little unsure as never done anything like this!
Please help!!
The Tables I have are:
tblStock
tblCategories
tblSuppliers
tblInventory transaction
tblStock_in
tblStock_Out
tblEmployees
Is this sufficient? Can i add stock and take stock out with one transaction table? Or would i need to add another table? I believe the code would be through a query but again am a little unsure as never done anything like this!
Please help!!