Converting Single-Reference to Multi-Reference Column

Say you created the “Language” single-reference column of many-to-one relationship. This column allows to assign one language to each conference session. Then you realized that you need a multi-reference column to assign many languages to each session. To convert a single-reference column to a multi-reference column, perform one-step conversion via the Convert to Multi-Reference button.

Make the following adjustment:

Click the Setup link in the top right corner of the window.

Select a table you need (for example, the “Sessions” table).

From the setup menu select Columns > Customize existing columns.

Find the single reference column you want to convert to the multi-reference column. (In our example this is the “Language Single Reference” column name link.)

Click on the column name link.

After that the column form is opened.

Click on the Convert to Multi-Reference button.

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

Moreover, the additional “Language Sessions” table comprising all necessary relations with the data stored in the previous single reference column is created automatically.

This additional table is obligatory and it works like the intermediary between the “Sessions” table and the “Languages” table collecting the Session-Language combinations. This “Language Sessions” table is hidden by default, so you can find the tab only in the 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.

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

As a result, many languages can be added to each session.

Next: Creating a new Lookup Column