Ref column looking at wrong column - stumped!

[Chris_Bean1]

Hi folks

Strange one here - I've got a column set up as a ref to another tab, nothing weird there, but in the app UX it looks at a completely different column

When I go to the UX, it shows this - clearly not a list of store numbers! 

I've happily used refs before and the ref is working fine on the same data in another app. 

Help! 

Thanks

Chris

[Joseph_Seddik]

Please take the following into consideration:

1. Ref columns will store the values of the Key column in the referenced Source table. 
2. UX will display the values of the column set as Label in the referenced Source table. 

[Chris_Bean1]

Ok. Unfortunately I need the label to remain as the farm name because there is a map with pins that should show the farm name, not the store number. 

Is there a way around this? 

Cheers

Chris

[Joseph_Seddik]

Yes, add a new column with an explicit dereference expression.