Issue with Flexfield Defaulting to First Value in Value Set

Hi All,

I've created a flexfield with a value set based on a SQL query. However, the field is defaulting to the first value in the list, regardless of which value I select.

I’d appreciate any insights into what might be causing this behavior.

Thanks in advance!