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;

  1. Open the Schema Dictionary

    • Ensure your project has a schema.

    • Navigate to the Schema Dictionary view.

    • (See screenshot for reference.)

  2. 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.

  3. Edit Column Properties

    • An Edit Column dialog will appear with several configuration options.

    • (Screenshot provided for clarity.)

  4. 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.

 

 


Was this article helpful?