Views - Database Design for Mere Mortals - page 392

status, and the second view will provide information on the total number of different
products each vendor supplies.
You base the PREFERRED CUSTOMERS view on the CUSTOMERS table and use the
C USTOMER ID, C UST F IRST N AME , C UST L AST N AME , C UST H OME P HONE, and S TATUS fields
for the view's structure. Before you construct the view, however, Mike asks if there's any
way to display the first name and last names together. You respond that it can be done, so
youcreateacalculatedfieldcalledC USTOMER N AME thatconcatenatesbothofthefieldsto-
gether; this field will now replace the C UST F IRST N AME and C UST L AST N AME fields. Figure
12.17 shows the view diagram for the PREFERRED CUSTOMERS view.
Figure 12.17. View diagram for the PREFERRED CUSTOMERS view