# One-to-many relationship between tables

> Display one-to-many relationships in IS Tools. Show a parent record with its child records using Table sections or the Multi-value reverse relation field.

[Application configuration](application_configuration.md) > [Data model editor](data_model_editor.md) > One-to-many relationship between tables

A table can have relation with other tables, through fields of the type **_Relation_**. The table where the **Relation** field is created, is known as _child table_ and is subordinated to (i.e., points to) another table, known as _parent table_ or target table.

The simplest way to represent a relationship between tables is by adding the **Relation** field to a section of the child table, i.e., many children with one parent, also called _many-to-one_:

![Many to one](_images/one_to_many_relationship/Many-to-one.png)

But this relation can also be represented the other way around, that is from a section of the parent table showing a list of his/her children, i.e., one parent with many children, _one-to-many_:

![One to many1](_images/one_to_many_relationship/One-to-many1.png)

The above is accomplished by creating a section (any type) of the parent table and adding (inside or outside its panel) a [Table section](form_designer.md#Table) of the child table that depends on the parent.

It is important to note that the _one-to-many_ relationship can also be displayed by using the [Multi-value](field_types.md#Multi-value) field to show a quick list of the child records, but also convenient for deleting child records permanently, just by clicking their crosses and save (for further functionality you might need more advice from IS Tools support):

![One to many2](_images/one_to_many_relationship/One-to-many2.png)

For that, once you have selected the parent table in Form designer, look for the ![Reverse relation](_images/Reverse_relation.png) _reverse relation_ icon and click on it to display an _additional panel_ where fields of the child table are listed, including the **System defined fields**, from where **the Record name can be added**. Other fields from the reverse relation panel can also be added.

Read more about relation between tables [here](tables.md#_relations_between_tables).