I have a dialog list field which looks up the values from another database. This all works fine, however on choosing a value, then re-entering the field, the string which was selected before all get appended to the end of the list as separate elements, split at the spaces.
e.g. I choose [Place Name Number] from my list. When I open the dialog again, [Place Name Number] appears as an entry in it’s normal place, and at the bottom of the list is now [Place] [Name] and [Number] as separate entries, with the last one in the list highlighted.
I use Cache for the lookup, but using NoCache gives the same problem. Allow Values Not In List is not ticked in the field properties.
Other options I have toggled and the problem still remains.