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?