Converting Single-Reference to Multi-Reference Column

Suppose you’ve created the "Language" single-reference column with a many-to-one relationship. This column allows you to assign one language to each conference session. However, you’ve realized that you need a multi-reference column to assign multiple languages to each session. To convert a single-reference column to a multi-reference column, follow these steps:

Make the following adjustment:

  1. Click the Setup link in the top right corner of the window.
  2. Select the table you need (for example, the "Sessions" table).
  3. From the setup menu, select Columns > Customize existing columns.
  4. Find the single-reference column you want to convert to a multi-reference column (in our example, this is the "Language Single Reference" column).
  5. Click on the column name link.
    Single Reference Convert
  6. The column form will open.
    Convert to Multi Reference
  7. Click on the Convert to Multi-Reference button.

As a result, the system will create a new multi-reference column.

Multi reference

Additionally, an additional "Language Sessions" table that includes all the necessary relations with the data stored in the previous single reference column will be created automatically.

This additional table is obligatory and serves as an intermediary between the "Sessions" table and the "Languages" table, collecting the Session-Language combinations. The "Language Sessions" table is hidden by default, so you can find the tab only in Setup mode.

To check this new multi-reference column, create a new record or edit an existing one and review the list of values displayed in the multi-reference field.

To add a language to a session, use the Add button.

Single & Multi reference

To complete the conversion, you must delete the previous single reference column. You can also rename the created multi-reference column, reorder columns on the form, or reorder columns in the view as you like.

As a result, you can now add multiple languages to each session.