Converting Many-To-One to Multi-Reference Column

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

For conversion use the following steps:

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.

Select the many-to-one reference column you want to convert to the multi-reference column.

Click on the Convert to Multi-Reference button.

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

Also the additional “Language Sessions” table comprising all necessary relations and the data stored in the previous many-to-one 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 column.

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

To complete the conversion you have to delete the previous many-to-one reference column. Also you can rename the created multi-reference column and reorder columns in 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