O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

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 Lookup Fields in a Web Database

If you’ve been following along in this chapter, creating the Vendors web table in your Restaurant Database, you’ll remember we are still missing one more field found in the tblVendors web table in the Back Office Software System sample web database on the companion CD—the State field. If you open the tblVendors web table in the BOSSDataCopy.accdb database in Datasheet view and tab to the State field, you’ll notice that Access displays a drop-down list of states, as shown in Figure 6-43.

The State field in the tblVendors web table is a Lookup Field that displays a list of state abbreviations.

Figure 6-43. The State field in the tblVendors web table is a Lookup Field that displays a list of state abbreviations.

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