How to Concatenate 2 Single Select fields into text

Get Help
1

I have a table with columns [Exchange] and [Ticker]. These are both single select types.

I wish to make the primary key [Exchange] + ": " + [Code] but I get this error

Cannot add Tickers Exchange and Tickers Code

Is there a way around this?

,Thanks

2

Try
Exchange.Name + “:” + Ticker.Name

1 Like
3

Just noticed that your original post is a bit confusing (are the single selects called Exchange and Tickers or are they called Exchange and Code?) so it’s possible that the right formula is actually

Exchange.Name + “:” + Code.Name

4

Thank you that worked :slight_smile: