Combo-box, dynamic choice - return another value than displayed

ekwo

Hi
I have a similar issue explained in this topic: Problem Filtering Drop Down List Choices>
I want a drop-down list on a form column that lists fields from one BO dependent on a column value in the current form. Is it possible to List one value and return another value? eks list Description and return ID ?

Evelyn

Jaymer

RegularUser BO. This shows the fields and sample data:
Name Jaymer
Initials Jay
DisplayCalc Jaymer (Jay)

The Calculated field is from a Rule Formula.

On a Job screen, the user picks the Salesman using the DisplayCalc field, that displays CHOICES from the user table.
Salesman Picker.png

Then, this rule fires, to lookup the Record and store the Initials (or ID# in your case).

If Job.SalesmanDisplay WAS CHANGED  Then 
FIND RegularUser WHERE RegularUser.DisplayCalc = Job.SalesmanDisplay
 Job.SalesmanInit = RegularUser.Initials