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...
Certain functions are common to almost all types of input and output. On a microcomputer, they are performed by each interface; in effect, they are duplicated for each device on the system. On larger machines, these common functions are assigned to a __________.
a. control unit b. interface board c. coprocessor d. channel
To design a recursive method, you must determine the limiting conditions.
Answer the following statement true (T) or false (F)
The 192.168.100.0 network falls within the private network range.
Answer the following statement true (T) or false (F)
The figure above is a portion of which of the following?
A. Print options bar B. Zoom Tool options bar C. Support dialog box D. Help options bar