I have a value list defined by a self join relationship. I see that there is a sort option in the relationship dialog box but no matter what I do, it is not having any effect on the value list (which defaults of course to alphabetical order).
The users now want to see the value list in the order in which the records were created. So I tried to sort by the primary key of that table. Hope this makes sense. I've attached some screenshots. Thanks.