ManyA many-to-many relationships allow relationship allows you to define connections between the entries records of any two tables, by specifying the relationship type other than “one-to-one.”
A many-to-one”many table is a table describing how two tables are linked with each other.
For example, the User and the Group tables may contain many records about with users and groups, accordingly. A user may be in more than one group, and a group may include many users, so, in this case, these two tables have to be are bound as shown below:
A many-to-many table is a table describing how two tables are linked with each other. You can find a typical example of such a linkage on the screenshot below:
здесь должно быть изображение
| Tip |
|---|
Role required: admin. |
To create a To create a new many-to-many relationship, complete the steps below:
- Navigate to M2M → Tables→ Create M2M tableNew.
- Fill in the fields.
- Click Save or Save and Exitexit to apply the changes.
Role required: security_admin.
M2M form fields
| Field | Mandatory | Description | |||
|---|---|---|---|---|---|
| Name | Y | Specify a relationship name. | |||
| Source column | |||||
| From Column Titlecolumn title | N | Specify the column title. It may differ from the column title in the table. | |||
| From Column Namecolumn name | Y | Specify the system name of the source column. You can use Latin letters, [0..9] numbers, and the underscore symbol ( _ ) are allowed.
| |||
| From Tabletable | Y | Reference to Specify the source table. | |||
| Target column | |||||
| To Column Titlecolumn title | N | Specify the column title. It may differ from the column title in the table. | |||
| To Column Namecolumn name | Y | Specify the system name of the target column. You can use Latin letters, [0..9] numbers, and the underscore symbol ( _ ).
| |||
| To Tabletable | Y | Reference to Specify the target table. | |||