Versions Compared

Old Version 1

changes.mady.by.user Dina Baksheeva

Saved on

compared with

New Version Current

changes.mady.by.user Dina Baksheeva

Saved on

Key

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

ManyA many-to-many inter-table relationships allow defining relationship allows you to define connections between the entries the records of any two tables, with by specifying the relationship type other than "one“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:

Image Removed

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 Removed

Image Added

Tip

Role required: admin.

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

  1. Navigate to M2M → Tables→ Create M2M tableNew.
  2. Fill in the fields.
  3. Click Save or Save and Exitexit to apply the changes.
Tip

Role required: security_admin.

Many-to-many relationship M2M form fields

FieldMandatoryTypeDescription
NameYStringA Specify a relationship name.
Source column
From Column Labelcolumn titleNStringSpecify the column label (it title. It may differ from the column title )in the table.
From Column Namecolumn 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 From Table field; otherwise, the relationship will be disfunctional.

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 TableYReferenceReference to the table containing the column to bind with another one specified in the To Column Name field.
Target column

. You can use Latin letters, [0..9] numbers, and the underscore symbol ( _ ).

Tip

After you created an M2M table, you can configure column settings in the relevant Column (sys_db_column) table record.


From tableYSpecify the source table. 
Target column
To column titleNSpecify the column title. It To Column LabelNStringSpecify the column label (it may differ from the column title )in the table.
To Column Namecolumn 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 field; otherwise, the relationship will be disfunctional.

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.

. You can use Latin letters, [0..9] numbers, and the underscore symbol ( _ ).

Tip

After you created an M2M table, you can configure column settings in the relevant Column (sys_db_column) table record.


To tableYSpecify the target tableTo TableYReferenceReference to the table containing the column to bind with another one specified in the From Column Name field.