Microsoft Access 2013 Inside Out

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