3305 Main Street Ste 019 Vancouver, WA 98663

Specify Key Values

This step of only appears when you have selected the DBLookup function. This step of the wizard requires you to supply a value or cell reference for each primary key column of the table that you selected. Values in the primary key columns serve as the unique identifiers for each row in the table. No two rows in the table will ever have the same primary key value. If the primary key consists of more than one column, the combination of the primary key values of a given row constitute it's unique identifier.

By specifying the primary key, Liberty Reports is able to locate a specific row in the table in order to return values from the column(s) you selected.

Name Description
Type Click this drop-down and select from one of the following options:
  • Literal Value - Select this option if you always want to locate the row in the table using the same value for the primary key field.
  • Cell Reference - Select this option if you want to locate the row in the table using the value that is contained in a cell on your worksheet.
Value This option appears when the Type is Literal Value. You may identify the desired value one of two ways:
  • Type the value in the box. The value that you type must be of the appropriate type for the column. In other words, if the column holds date values, enter a date. If it holds numbers, enter a number.
  • Click the drop-down and select from a list of values that is queried from the database.
Cell This option appears when the Type is Cell Reference. You may identify the desired cell one of three ways:
  • Type a valid cell reference (e.g., Sheet1!$A5)
  • Click the drop-down and select a named cell.
  • Click the cell-selector button and then click on the desired cell.
This step only applies to the following functions:
  • DBLookup