Afternoon Folks, I am struggling with getti...

[Sam_Arthur]

Afternoon Folks,

I am struggling with getting a ref column to work (i am probably being thick!) and any help would be greatly appreciated.

I have 2 columns I have merged into one. one is a job number the other is a job name. it now reads as “8759 - Birmingham Interchange”

I cannot for the life of me get the app to show me this info as a ref in a dropdown list. I have set this column as the key but the best it manages is to give me the name and not the number. is there a reason this is happening?

cheers

Sam

[Aleksi_Alkio]

Check the label field. It should be the same if that virtual column is a key column.

[Sam_Arthur]

Thanks Aleksi, that seems to ha e sorted it!