How To Create A Lookup Field In Access 2010


show more Creating a lookup field provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Creating a lookup field

Lookup fields allow the database user to choose data from a list instead of typing in their own fields. This both speeds up data entry and reduces errors. When using a Lookup field, you can either reference data in another table or type in your own list. So let's create our fourth table, one to take our orders. Click on the Create tab and then click on Table Design. First, we need an OrderID, essentially an invoice number. Let's use the AutoNumber Data Type.

This will also be our unique identifier. So click on the Primary Key button. Next, we need the date of our order. Enter in "OrderDate" and choose Date/Time for the Field Type. Next, we need to know who was placing the order. We'll do a Lookup field to reference the customer's ID, and as an added bonus use the company name to help us know who was who. So enter in Customer and, from the Data Type list, choose Lookup Wizard.

In the dialog box, leave it on the default so that we can get the data from another table and...

Creating a lookup field
Video duration: 3m 59s 3h 30m Beginner

Viewers:

Creating a lookup field provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...