I am trying to build a Query that will look at an inventory. If there is no inventory left it will not allow it as a selection or give message closed.
The Northwind Template in Access 2010 has a similar function. When you place a new order it will ask you for quantity. If you select it and there is no quantity left it will give you error message.
I recognize I need a:
TABLE - Inventory - Where I can update volume/quantity
Form - Method to order
Query - That would reference table and volume/quantity and return message.
What I would actually love, love to have is a method where for example I have 10 Apples available. 10 people place orders for Apples. Therefore no Apples left. the 11th person doesn't even get Apples as an option to order because it is no longer available versus try to order and get message above stating closed. That would be PERFECT!.
I would love insight on how to do this. Did my best trying to figure it out on Northwind Template...but my knowledge is limited.
My thought is maybe this is an append to the table or the like. Unsure
Thank you in advance.