Lookup key

To link tables to one another, we've introduced a Lookup Key to the Design tab of each data table. 

The Lookup Key serves two functions:

  1. It produces a unique value for each row in a table that is used to link each row of a table to a row in another table.
  2. You can configure it to display information in a different table in a specific format.

To begin entering a Lookup Key, click in the text box and add a bracket. This will give you a dropdown menu of all columns in your table. You can continue typing the name of the column or click on the column name to select it.

In the following example, we've created a unique Lookup Key by combining Trainee ID and Sex. The Lookup Key in this case is [Trainee ID][Sex].

If we were to link a row in this table with a row in a different table, a row where Person ID is "123" and Sex is "Female" will now display as "123Female".   

To configure the Lookup Key in a specific format, users can add spaces and special characters between column names. In the example below, we've made the Lookup Key and display more readable by adding a comma between the Person ID and Sex.  

NOTE: If a Lookup Key cannot produce a unique values for all rows, you will receive an error message asking you to add additional columns to the Key until each value is unique. Similarly, if data is being added to the table that will render the Lookup Key not unique, you will be prompted to fix the duplicate data.

You can now use the Lookup Key to Link Data Tables.

Didn't answer your question? Please email us at help@devresults.com.