Versions Compared

Old Version 2

changes.mady.by.user Dina Baksheeva

Saved on

compared with

New Version 3

changes.mady.by.user Dina Baksheeva

Saved on

Key

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

Many-to-many inter-table relationships allow you to define connections between the entries of any two tables, with 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, please 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.
Tip

Role required: security_admin.

Many-to-many relationship M2M form fields

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

. Latin letters, [0..9] numbers and the underscore symbol ( _ ) are allowed.

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

. Latin letters, [0..9] numbers and the underscore symbol ( _ ) are allowed.

FieldMandatoryDescription
NameYSpecify a relationship name.
Source column
From Column LabelTitleNStringSpecify the column label (it title. It may differ from the column title )in the table.
From Column NameY

Specify the column to bind with another one. Use the system name of the column taken from the source column properties. The column should be presented in the table specified in the From Table field; otherwise, the relationship will be disfunctional.

Tip
From TableYReference to the table containing the column to bind with another one specified in the To Column Name field.source table. 
Target column
To Column LabelTitleNStringSpecify the column label (it may differ from the column titletitle in the table).
To Column NameY

Specify the column to bind with another one. Use the system name of the column taken from the target column properties. The column should be presented in the table specified in the To Table field; otherwise, the relationship will be disfunctional.

Tip
To TableYReference Reference to the table containing the column to bind with another one specified in the From Column Name fieldtarget table.