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 table | Extended tables |
|---|---|
| Task |
|
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.
| Info |
|---|
When a child table is created, its list and form views are copied from the parent table, taking into account section views and related lists. You can set up these views later. Refer to 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.
- System fields are created in the new table (like the sys_id field).
All Tables Dictionary
| Tip |
|---|
Role required: admin. |
Instance administrators can use the All Tables dictionary to understand relationships between tables. To use the dictionary, complete the steps below:
- Navigate to System Definition → Settings → All Tables.
- Find the table record you need by typing its title in the search box.
- Navigate to this table.
- The value in the Parent field is the title of the parent table, the one the current table is sharing fields with.
| Tip |
|---|
Also, the parent table can be quickly discovered if you have previously configured your list layout to display the Parent field. See the List Layout article to learn more. |