This content has been marked as final. Show 2 replies
FYI, I solved with creating a new relation, but can it be done with a calculation?
Another option is to use the "pop up" menu option instead of the drop down option.
After exiting the field, Pop Up menus will display the matching visible column value instead of the hidden first column value the way drop down lists do.