AnsweredAssumed Answered

Field showing key value, instead of text value, after import

Question asked by davehob on Mar 5, 2015
Latest reply on Dec 30, 2016 by ChrisVanBuren

A field is defined to hold the key (id) of a related field, but to show the associated text value (control style = popup menu, values from a value list - the value list is defined to use values from the id and the text field, and to "show values only from second field"), the end result being that the text field is displayed, even though the id is what is stored. 

This all works fine, until now, when I've done an import of data.  On the imported data, some (most) of the records are fine - they show the text field - but others show the id itself.  I've looked at the source data, and can't see a problem with it. If I select the required value from the value list, it's fine.  (But I don't fancy ploughing through 4000+ records to correct every problem record!)

Any idea what I may be doing wrong?