Explain how you ensured that an order cannot be placed if there are not enough items in inventory
What will be an ideal response?
To ensure that an order is not placed unless there is enough of that item in inventory, a combination of Before Change Data and After Insert Data macros were used in the tblOrders table. The Before Change Data macro looks up the matching item in the tblInventory table and uses an IF statement to raise an error if the quantity sold is greater than the number in stock. If there is enough in inventory to proceed with the order, then the value is entered. The After Insert Data macro is again used to lookup the item in inventory being ordered and subtract the quantity sold from the units in stock.
You might also like to view...
A certificate is typically designed in ________ orientation
Fill in the blank(s) with correct word
The labels located at the bottom of the workbook window that identify each worksheet are called worksheet ________
Fill in the blank(s) with the appropriate word(s).