Versions Compared

Old Version 10

changes.mady.by.user Artem Didyk

Saved on

compared with

New Version Current

changes.mady.by.user Anna Kryzhanovskaya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Many-to-many intertable inter-table relationships allow defining connections between the entries the entries of any two tables, with 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 in one group, and a group may include any many users, Soso, in this case, these two tables have to be bound as shown below:

Image Modified

The 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:

Image Modified

To create a new many-to-many relationship, please complete the steps below:

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

Role required: security_admin.

Many-to-many relationship form fields

FieldMandatoryTypeDescription
NameYString
Relationship
A relationship name.
Source column
From
table
Column LabelNStringSpecify the column label (it may differ from the column title).
From Column NameY
ReferenceReference to the table containing the column to bind with another one specified in the To column name field.From column name
String

Specify the column to bind with another one. Use the system name of the column taken from the column properties. The column should be presented in the table specified in the From

table

Table field; otherwise, the relationship will be disfunctional.

From column labelStringSpecify the column label (it may differ from the column title).Target column


Tip

To get the system name of a column, please navigate to the All Columns list or to the Realted Lists area in the table form.


From TableY
To table
ReferenceReference to the table containing the column to bind with another one specified in
the From column name
the To Column Name field.
Target column
To
column name
Column LabelNStringSpecify the column label (it may differ from the column title).
To Column NameYString

Specify the column to bind with another one. Use the system name of the column taken from the column properties. The column should be presented in the table specified in the To

table

Table field; otherwise, the relationship will be disfunctional.

From column labelStringSpecify the column label (it may differ from the column title).
NoteIn fact, the many-to-many relationship is a table, so you can navigate into it and browse the records. In the example above (theme_has_documentation), navigate to 
Tip

To get the system name of a column, please navigate to the All Columns list or to the Realted Lists area in the table form.


To TableYReferenceReference to the table containing the column to bind with another one specified in the From Column Name field
{your_instance_url}/list/theme_has_documentation
.