Many-to-many relationships allow you to define connections between the entries of any two tables, by specifying the relationship type other than “one-to-one”.
For example, the User and the Group tables may contain many records about 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 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:
To create a new many-to-many relationship, complete the steps below:
- Navigate to M2M → Create M2M table.
- Fill in the fields.
- Click Save or Save and Exit to apply changes.
Role required: admin.
M2M form fields
| Field | Mandatory | Description |
|---|---|---|
| Name | Y | Specify a relationship name. |
| Source column | ||
| From Column Title | N | Specify the column title. It may differ from the column title in the table. |
| From Column Name | Y | Specify the system name of the column. Latin letters, [0..9] numbers and the underscore symbol ( _ ) are allowed. After you created an M2M table, you can configure column settings in the relevant Column (sys_db_column) table record. |
| From Table | Y | Reference to the source table. |
| Target column | ||
| To Column Title | N | Specify the column title. It may differ from the column title in the table. |
| To Column Name | Y | Specify the system name of the column. Latin letters, [0..9] numbers and the underscore symbol ( _ ) are allowed. After you created an M2M table, you can configure column settings in the relevant Column (sys_db_column) table record. |
| To Table | Y | Reference to the target table. |
