Strange EnumList Ref Behavior

[ezosoro2]

Hello all,

I know that Enumlist with a base of Ref has some issues, but I have an odd one, for most of my rows it works as expected and shows the referenced table's label (Employee Name) instead of the key (Employee ID), but there's one row that shows the key. If I delete and add again, in the form it shows correctly, and then in the view it is correct but as soon as the sync finishes it shows the key not the label. There is a formula in this column:

select(Job[Employee ID],and([Date]=[_THISROW].[Date],[Work Code]="Trainee"))

but I don't see any reason why a particular date would show differently. Also, I have tried listing the Table[Key] in Valid If and Suggested values with no behavior change. I can't use a straight reference because the formula above is giving me a list of Employee IDs and we know how Appsheet likes lists in a static column. And I'd like to avoid virtual columns for performance reasons.

I hope I explained this well, I can't really share a screenshot as it's sensitive data.

[AleksiAlkio]

When you select the value, what it shows in the data source? Does it show a value that exists in your Job table? Have you specified the Job table as a Ref table in your EnumList table? It should match or at least the exact value should be present if the Ref table is different.

It sounds the Job table is not the Ref table.