Mila Shvets 6/11/2021 4:30:11 AM
It is possible to use only one column.
In the reference column settings you can choose the Proxy Column.
You may read more about the Proxy Column here https://www.teamdesk.net/help/4.6.18.aspx
When the Proxy Column is chosen, the system creates a lookup column automatically. This lookup column displays the Proxy Column values.
As the result, you should use just the created proxy lookup column in a view with the activated Inline Edit option.
In this case when you click on the Edit button in the view, the proxy lookup column is replaced with a record picker.
For example, you have the "Client" single-reference column keeping clients' Id values. You choose the "Company" column as the proxy column in the reference column settings. When you save this change, the "Client Company" lookup column will be created by the system. After that you can use only the "Client Company" lookup column in the view with the activated Inline Edit option.
More details about the Proxy Column and the Inline Edit option are described in the paragraph#8 here https://www.teamdesk.net/blog/tips-tricks/single-reference-column-relation/