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:
- 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.
- 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.
You can now use the Lookup Key to Link Data Tables.
Didn't answer your question? Please email us at firstname.lastname@example.org.