Search results

thats brilliant so the table set up would be like this... Then there would be a function in a form connected to the sock_calc table that would calculate the current level of stock?

Cheers guys, All that tread reading has certainly enlightened me. Now this may be a stupid question, but would i hold the total quantity of the product within the Stock table? And then just update that from the transaction table through the stock_in and stock_out. Any suggestions would be great..

How do you pull a fat bird? Piece of cake!

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...