How do you set how the values are sorted when you are using a value list from fields?
When I select "Show only values from the second field" the "Sort values using" is dimmed and automatically set to the second field, which sorts alphabetically. However, I want to sort it by the first field which is numerical so that I can use a custom sort order with the most frequently used choices at the top. But I don't want the first field to appear in the pop up field of choices. I tried setting the sort order in the relationship graph to no avail.
I've attached the relevant portion of the relationship graph and the value list set up dialog box for your review. Any help would be appreciated.