Greetings:
I am displaying the results of a database lookup in a calculated field. It all works well except in Display mode, where the string ";#" is appended to the end of the string in the calculated field control. (See image below.) Does anyone know why this happens and how to prevent it? I might expect this when the display format of the database lookup is "Dropdown Menu" since the ";#" separates the value and display components, but in this case the display format is "label" so I don't know where this string is coming from.
Thanks,
Bruce