I have a similar problem. I am using a Sharepoint list as a data connection and depending on how I have the list ordered changes the outcome of my values.
For example, complexity ratings corresponding to high, med, low are stored as 3 separate columns off the associated description.
A separate control allows the user to select which ...