Lookup Wizard in Microsoft Access 2013 and 2016

The Lookup wizard in Microsoft Access 2013 is the feature for creating the lookup field. With the lookup field, you can create the relation for one table with other tables or query. For better explanation, drop down menu in the table is the sample of the lookup field.
To create the Lookup field, follow these instructions:

1. Open the table or query. In this tutorial, let use the Book library database.

Lookup Wizard Access 2013-1

Lookup Wizard Access 2013-1

2. In the new field/column header, click the drop-down menu. Select “Lookup & Relationship”.

Lookup Wizard Access 2013-2

Lookup Wizard Access 2013-2

3. In the Lookup wizard, select “I want the lookup field to get values form another table or query”. Then, hit Next.
4. Select the table or query to be created as lookup field. Then, hit Next.

Lookup Wizard Access 2013-3

Lookup Wizard Access 2013-3

5. Select which fields that meant to be option in the lookup field. Click Next.

Lookup Wizard Access 2013-4

Lookup Wizard Access 2013-4

 

6. From the selected fields in previous steps, choose which will be appear in the option value in lookup field. You can choose up to 4 options. Select the sorting (Descending or Ascending).

7. Next, choose the options view for the lookup field. You can hide the preview of the primary key by ticking the check-boxes. Click Next.

Read Also:  Access Database Multiple Users Split and Share

8. Rename the field. Then, tick one of the following check-boxes (optional).

a. Enable Data Integrity: if you choose this, the changes in the parent table (the table where you take the lookup field from. In this tutorial: Member table) will be affect the records in the child table (Borrow table). There is two options for Data Integrity. “Cascade Delete” means if you delete one of the record in parents table, it will automatically delete the records that contains the deleted data in the child table.

Example: Delete the Member named Danang. The borrow records with Danang as the member will be deleted.
“Restricted Delete” means that you cannot delete the records in the parent table if in it exist in the child table.

b. Allow Multiple Value: by choose this, you can add more than one value in the options

Lookup Wizard Access 2013-5

Lookup Wizard Access 2013-5

If you don’t tick any check-boxes, it will work as default drop down menu.

Lookup Wizard Access 2013-6

Lookup Wizard Access 2013-6

Related Access Database

  • lookup wizard database definition
  • lookup wizard in access


Access Database Tags: #how to change a field to a lookup field in access #how to create an update query in access #how to use lookup wizard in access 2016 #lookup wizard access 2007 #lookup wizard access 2010 #lookup wizard access 2013 #lookup wizard access 2013 design view #lookup wizard definition

Ms Access Subquery in Select Statement Syntax
Ms Access Subquery in Select Statement Syntax
Ms Access Subquery syntax is the Select
MS Access Tab Control in Form Tables or Subform
MS Access Tab Control in Form Tables or Subform
Access Tab Control is mainly used in
MS Access Left Function in SQL Query and VBA Code
MS Access Left Function in SQL Query and VBA Code
Ms Access Left Join function or sometimes


Must read×

Top