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.
Figure 6-43. The State field in the tblVendors web table is a Lookup Field that displays a list of state abbreviations.
Get Microsoft® Access® 2010 Inside Out 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.
