O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

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

Creating value list lookup fields in web apps

If you’ve been following along in this chapter, creating the Vendors table in your Restaurant App, you’ll remember we are still missing one more field found in the tblVendors web table in the Back Office Software System sample web app—the State field. We defined the State field in this table to be a lookup field. A lookup field can generally be classified as one of two types—a field that “looks up” its data from a predefined list stored with the field itself or a field that looks up its data from a different table. The State field in the tblVendors table looks up its data from a predefined list I provided when I created the field. Microsoft also uses the term value list to describe this type of field ...

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