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:  Nonprofit Fundraising and Donation Management Software for Ms Access

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

  • definition of lookupwizard
  • definution of lookup wizard
  • lookup d access 2010 и access 2013
  • lookup wizard relationship affect 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 VBA Close Workbook and Form
MS Access VBA Close Workbook and Form
In this tutorial, we use Ms Access
MS Access DB and MDB Viewer Software
MS Access DB and MDB Viewer Software
Access DB Viewer is the software to
MS Access Validation Rule Lookup Table Examples
MS Access Validation Rule Lookup Table Examples
The Validation Rule in Microsoft Access is


Must read×

Top