Create a field that looks up or lists values in tables

Using the Lookup Wizard, you can create a field that displays either of two kinds of lists to make data entry simpler:

• A Lookup list that displays values looked up from an existing table or query
  
  
• A value list that displays a fixed set of values that you enter when you create the field

What do you want to do?

Create a Lookup list field in Design view

Create a Lookup list field in Datasheet view

Create a value list field in Design view

Create a value list field in Datasheet view

Not sure which choice you want?