I'm really hoping someone can help me. I've run into this issue several times now, before I was able to 'fix' it as I was dealing with list values from an external source (SQL view).

For example, I have a size 10 varchar field to store a colour code. A valid colour code may be 'BRN', and I can see that this value is populated in the table. The list values (internal, not external), have an option 'BRN;BROWN' as one of the lines.

If this row is edited, BROWN is not shown in the field, even though the populated value is BRN. I have tested and it seems related to the field size; Indoogrid is matching 10 characters or something? If I change the stored value to BRN4567890 and the option to BRN4567890, it shows BROWN when editing this record as I would expect.

Any suggestions?

Thanks,

Matt