Hi Carmen, I could not find a solution and created a view in SQL server. I use the view in my data connection.
example:
------------------------------
Renette Nienaber
Mrd
VIVO ENERGY SOUTH AFRICA (PTY) LTD
------------------------------
Original Message:
Sent: 03-03-2026 11:39
From: Carmen Hernandez
Subject: Data Connections in Drop downs - Can you merge the values for a drop down?
We are working on pulling from a SQL table into a drop down to show values. However, we would like to see if we could merge the values in the drop down for the Plant ID and Plant Name. So for example 1234 - Test.
Is there anyway to have this done? I was looking at the filter but didn't look like there was anything there.


------------------------------
Carmen Hernandez
Conagra Brands, Inc.
Chicago IL
------------------------------