" - " and @dbLookup

I have a dialog list @dbcolumn field that looks up state values in a view such as :

KY - Kentucky

NJ - New Jersey

NY - New York

When I have a computed for display field that does an @dblookup on the same view with that selected value as the key and it cannot find the value.

Is it the " - " ?

Subject: " - " and @dbLookup

Have you checked there are no trailing spaces on the values?

Selecting your text there appears to be one on the end of "NJ - New Jersey ". Might be worth a check

Subject: " - " and @dbLookup

check the value separators in the calculte fields…You have the " " for separator for the moment