How to display the value of a display-type 'Combo' in a query

How do I?
1

Hello, I have a display type ‘Combo’ with a list of Key-Values. In a query, I would like to display the value instead of the key. My solution is to create a table corresponding to the display type then add this table to my query with JOIN. Is there an easier way to display the value in the query? Thanks!

Jean

2

Ok, I answered myself. I use this query as a source in a data view and the value is displayed - not the key - as long as I set the right display type in the data view field. Nice feature :slight_smile:

3

HI Jean,

Yes, you are correct, we display the value and store the key, glad you worked this out!

Kind regards,

Jo

1 Like