Pattern 8: Classic Joined Column
In this design pattern, in addition to or instead of a foreign key field, a name field from the parent table is shown.
For example, a Participants page contains a PERSON_ID field, and you want to add a (virtual) FAMILY_NAME field from a PERSON parent table.
To implement this joined column functionality:
The name of this TableDataSource usually starts with: Lookup.
The top area of the object tree now looks like this, for example:
In single-record layout (that is: in the SearchColumnGroup or the SingleRecordResultGroup), you can insert any ColumnControl, for example a TextColumnControl.
However, you can also insert a SelectColumnControl or RadioColumnControl to display the retrieved values as radio buttons or as a dropdown list.
In multi-record layout (that is: the MultiRecordResultGrid in the GridGroup), you need to insert a GridCellControl.
For a (multi-record) GridCellControl, set the Lookup Data Source Name (Behavior) property to the name of the added data source.