Skip to main content
Version: 1.22.3

Table Extension

The table extension functionality is available when creating a table record. It allows child tables to inherit the fields of the parent table.

The table extension is used for a set of records to share information with each other.

In the following use case, the Task table has multiple extensions:

Original tableExtended tables
Task
  • Incident
  • Request
  • Problem

An extended table is called a child table, and the original table is called a parent table. A child table, in its turn, can also be extended, and can have child tables.

note

When a child table is created, its list and form views are copied from the parent table, including section views and related lists. You can set up these views later. See the Form Layout and List Layout articles to learn more.

Table extension leads to the following:

  • A new table and an extended one are linked.
  • New system fields are created in the new table (for example, the ID field).

All Tables dictionary


tip

Role required: admin.

Use the Table (sys_db_table) dictionary to see relationships between tables. To do so, complete the steps below:

  1. Navigate to System Settings → All Tables.
  2. Find the table record you need using the list search boxes or condition builder.
  3. Navigate to this table.
  4. The value in the Parent field is the title of the parent table, the one that the current table is sharing fields with.

For quick access to the values of the Parent field, set up a list view. See the List Layout article to learn more.