Value List and Second Field Calculations
I am making a value list that is populated from an existing field in my database. When I elect to display value from second field I get a '?' in the pop-up box - this second field is a concatenated calculation of Fname & LName and displays properly in my table view
... when I don't elect to display value from second field I get the primary key values (which is the field that it is supposed to show) - i.e. __pkEmplID which is 1, 2, 3 etc.
Here's the rub - when I decide to show a different field as the second field (i.e. just FName), it does show up i.e. 1 Jane or 2 Bill
Is the fact that one of them is calculation vs. not make the ? show up, or am I doing something else wrong