Multivalue Fields

Suppose you're a company that sells food items, like Northwind. You have a Products table with all the items you sell, with one row for each item: ice cream, yogurt, nondairy creamer, and so on. Among the columns, you include a field to store all the flavors for that item: vanilla, blueberry, Irish crème (see Table 2.14).

Table 2.14. Tables That Include Multivalue Fields
Products
ProductSupplierFlavors<<other fields>>
Ice creamFrozen DelightsVanilla, Chocolate, Strawberry 
YogurtHeavenly CulturesVanilla, Blueberry, Asparagus, Strawberry 
Nondairy CreamerFoodstuffs Inc.Vanilla, Asparagus, Hazelnut 
Authors
Last NameFirst NameMajor Works<<other fields>>
DostoevskyFyodorThe Brothers Karamazov, Crime and Punishment, The Idiot, The Gambler ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.