*With the lookup technique, it is possible to select an item from another list and display one column of this item
*It is obviously possible to create several lookup columns on the same list and therefore display several columns
*There’s a high risk of not selecting the same item and therefore have inconsistent columns
*The Requirement therefore consist of being able of displaying several columns of the same item from the other list, based on one unique selection
Example:
In list(x), define lookup column on list (y), column Title (possible today)
Then define a “secondary” lookup column on same list, column Code
The effect would be that when selecting an item from list (X), both Title and Code would show up consistently in 2 different columns of list (Y)
All possible solutions are welcomed:)