using VBA between 2 tables

[Tech]

Hi, i hope this is the right place to post this

I am wanting to know, I am making an order type database and it has stock control,

if we have a table with product information, containing the stock, and we have an order form, how can I make it so that, once the order has been placed, after clicking a button, tell it to take away the qty ordered from the order form, to the total in stock in another form/table?

is it possible?

ftp://temp:temp@techftpserver.co.uk/mdffc.zip

I have like 5 text boxes in the order form, where the customer can order up to 5 items per order. Now, I have set traps where if the QTY ordered is > than the stock, don't allow them to order, so the user has to change it. if all success, when they hit the add new record button, on that event, it should take the product number from each row, and match it with the product number in the product details form and when it finds it, it should do the calculation of subtracting the QTY value from the Stock in total value, in the Product details form.

 

[Jack Cowley]

To learn more about inventory control I suggest you read and study the article you will find here.

Good luck!

Jack

 

[Tech]

tyvm

it's complicated for a beginner like me!

 

[Jack Cowley]

Yes it is! Inventory control is a complex issue as you just discovered. You can, of course, use update queries, etc. to change values in your tables but this goes against the rules of good database structure and normalization. I realize that the issue is not easy, but if you spend the time to try and sort it out it will stand you in good stead for all your future database development.

Jack