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:

  1. Navigate to M2M → Create M2M table.
  2. Fill in the fields.
  3. Click Save or Save and Exit to apply changes.

Role required: admin.

M2M form fields

FieldMandatoryDescription
NameYSpecify a relationship name.
Source column
From Column TitleNSpecify the column title. It may differ from the column title in the table.
From Column NameY

Specify the system name of the source 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 TableYReference to the source table. 
Target column
To Column TitleNSpecify the column title. It may differ from the column title in the table.
To Column NameY

Specify the system name of the target 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 TableYReference to the target table.