Column from a linked table

The Column from a linked table column displays, in your table, a value taken from a linked table through a Link to another table column. If you know Excel, this is the equivalent of a VLOOKUP.

This column needs a Link to another table column already present in the current table: it indicates which linked table to query. See Link to another table.

Summary

Create the column Options The result Go further

Create the column

In the table where you want to display the data, insert a new column and choose its type.

Type
Select Column from a linked table as the column type.

Linked column
Choose the Link to another table column to base it on.

Data to retrieve
Select the column of the linked table you want to display.

View
Choose the view of the linked table to use, then insert the column.

Insert field window, Column from a linked table selected as type

Example: in a Talents table, a Link to another table column points to the Staff register. The Column from a linked table column can retrieve the Status column from it.

Example: retrieving the Status column from the Staff register table

Options

Two options are available when the column is created.

Display as tags

Changes how the column is presented and gives direct access to the linked record by clicking the tag.

Include in form mode

Displays this column in the external form linked to the table.

The result

Once inserted, the column automatically shows the retrieved value, with no re-entry. If the data changes in the linked table, the column updates.

The column displayed in the record, with the retrieved value

Go further

Source column

Link to another table

The column that links your tables together, a prerequisite for this column.

Read more →

Display

Types of link views

Choose the best view of the linked table.