Setting a Column as a Table Label
A Table Label is a column that represents how rows from a foreign key (lookup) table are displayed. When a table is used as a lookup in another table, the Table Label column is the one shown to users instead of just displaying the raw foreign key value.
Why do I need a Table Label?
For example, if you have a Departments table, you may want the DepartmentName column to be the Table Label. That way, when another table references Departments, users will see “Human Resources” instead of an ID like 3.
This can be configured by following the steps below;
-
Open the Schema Dictionary
-
Ensure your project has a schema.
-
Navigate to the Schema Dictionary view.
-
(See screenshot for reference.)
-
-
Select the Column
-
Locate the table and column you want to set as the Table Label.
-
Right-click on that column.
-
From the menu that appears, choose Edit.
-
-
Edit Column Properties
-
An Edit Column dialog will appear with several configuration options.
-
(Screenshot provided for clarity.)
-
-
Enable Table Label
-
In the dialog, find the checkbox labeled Set as Table Label.
-
Check this box to designate the selected column as the Table Label for its table.
-