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 andor as you like.
As a result many languages can be added to each session.
Next: Creating a new Lookup Column