I have created some Dynamic Fields that reference External Tables. However, I would like the drop down to display a description column, but store an identifier column.
e.g. Can the drop down display "Software and Maintenance Fees" but store "123456789" once selected?
I'm trying to use this functionality for things like GL Code - GL Description, Employee ID - Employee Name, etc.
Is this possible?