Suppose we have 3 warehouses: A, B and C and each warehouse has 5 Books.
Now, a customer orders 3 books, so we substract quantity in warehouse A to 2. The second customers also orders 3 books, but since in warehouse A we only have 2, and sending items from warehouse B (or C) takes a few days, we have to ask for a choice wheter the customer wants partial delivery or just wait until the books are on stock.
I suppose doing this in VB is a lot easier but I have no clue how to get data from access/excel to VB.
Thank you very much.