October 1997
Intermediate to advanced
1312 pages
38h 56m
English
The most common use of a drill-down form that displays a list of orders is to present the line items of a particular order. It's relatively easy to add and program a line items list box, based on the Order Details table, to the form you created in the preceding sections. An additional use of the line items list box is to verify that the cboProduct combo box correctly performs its assigned role.
Create the query and add the list box with the following steps:
1. |
Create a new query and add the Order Details and Products tables.
|
2. | Drag the Product Name field of the Products table and the OrderID, UnitPrice, Quantity, and Discount fields of the Order ... |
Read now
Unlock full access