There's a new checkbox in the inspector:
"Override data formatting with value list"
Check this box to show "Carrots" instead of "3" on the pop-up menu.
Yes, this is one of those changes that seems back to front. The quality of popup menus to actually show the second value in a list while holding the first value always struck me as pure genius—it saved the traditional workaround of stacking a second field over the top. To me the more sensible change would have been to allow this option in dropdown lists as well, but instead FM engineers went the other way. It seemed a backward step to make popup menu behaviour match dropdown list behaviour, rather than the other way around. Still, at least they left the better functionality in, it's just that now you have to choose it.
My experience differs from what you recommend. Using the checkbox doesn't produce the desired result.
Moreover, it is hard to imagine what someone had in mind with the "override formatting " instruction. What formatting gets overridden by a pop up menu? The field to which the control style is assigned can be formatted normally, conditionally, and/or assigned a style and this checkbox does nothing to defeat any of those.
What formatting gets overridden by a pop up menu?
I agree that the wording is a little odd, but as I understand it it means the value entered into the field is overridden by the value which shows in the value list—or to put it another way, the user sees what they chose from the list (the meaningful second field value), not what they actually entered (the primary key value from the first value list field).
That makes more sense. Maybe it should be "value overridden " instead of format?