O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required