Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Table The table extension functionality allows inheriting fields from a parent table. Tables are extended by administrators and developers while creating tables.is available when creating a table record. It allows child tables to inherit the fields of the parent table.
The table Table extension is used for a set of records to share information with each other.
In the following use case listed below, 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, i.e., a child table and can have child tables itself.
Info |
---|
When a child table is created, its list and form views are copied from a the parent table, taking into account section views of sections and related lists. You can set up these views later. Refer to See the Form Layout and List Layout articles to learn more. |
Table extending causes extension leads to the following:
- Cross-table linking between the A new table and the extending onean extended one are linked.
- System fields are created in the new table (like the sys_id for example, the ID field).
Image Removed
Image Added
All Tables dictionary
Tip |
---|
Role required: admin. |
Instance administrators can use the All Tables tool to understand the relationships between the tables. To perform this, please Use the All Tables (sys_db_table) dictionary to understand relationships between tables. To do so, complete the steps below:
- Navigate to System Definition → Settings → All Tables.
- Select Find the table you want by typing its title in the search barrecord you need using the list search boxes or condition builder.
- 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 known if you have previously configured your list layout to display For quick access to the values of the Parent field. For more information, please refer to the List layout article, set up a list view. See the List Layout article to learn more. |