Database Reference
In-Depth Information
Figure 12.18. The View Specifications sheet for the PREFERRED CUSTOMERS
view
Now you define the VENDOR PRODUCT COUNT view using the VENDORS and
PRODUCTS tables as the view's base tables. You use the V
ENDOR
N
AME
field from the
VENDORS table to display the names of the vendors. Next, you create a calculated field
called P
RODUCT
C
OUNT
to display the total number of products each vendor supplies. This
is the expression the field uses to calculate the total:
Count(ProdName)
Now you create a diagram for the view, as shown in
Figure 12.19
.
Figure 12.19. View diagram for the VENDOR PRODUCT COUNT view