I would like to show a dropdown with two colu...

[Yossi_Oulu]

I would like to show a dropdown with two colums, e.g. item catalog# And item description. Once the user select an item the item catalog# should be returned back as a result. How do I do that?

Thanks Yossi

[Aleksi_Alkio]

You can do that with a ref field. Your ref table should have a virtual column where you concatenate catalog# and description. When you choose this virtual column as a label and the catalog# is a key column, you will have that result. Another question is if that column catalog# can be the key column.

[Yossi_Oulu]

Hi Aleksi, This is indeed what I was trying, but it does NOT work. I get back the virtual column not the catalog# (which is the key).

[Aleksi_Alkio]

When you use the label feature, it will save the key column’s value to your database but it will always show the label value with your app. It seems that you want to use the label value in your dropdown, but when you have chosen the value and saved it, you want to show the key column’s value in the app, is this correct?

[Yossi_Oulu]

OK. Thanks a lot! Works! I wasted lots of time on this.

All I had to do is look at the database

Thanks for the clarification.

[Aleksi_Alkio]

You’re welcome