The Lookup Wizard - Select Columns screen allows you to define the columns that will be used with your lookup.

The Index column will be used to populate a parameter value when the lookup is used in a condition for a query. Select the required index column in the Index Column combo box.

If necessary the list of tables can be updated by clicking on the Refresh button.

The Description Column will be used to populate the selection list when the lookup is used in a condition for a query.

If you wish to use a database column to populate the description column, make sure the Calculated Column check box is not ticked, and select the database column.

If you wish to use a calculated column to populate the description column, make sure the Calculated Column check box is ticked, and press the Build Expression button to open the Calculated Column dialog box to define the expression for your description column.

Click on the 'Next >' button to go continue to the Lookup Wizard - Lookup Options form. Click on the 'Cancel' button at any time to leave the Lookup Wizard without saving any changes. Click on the '< Back' button at any time to step back and review your work.