I am using SharePoint 2007 (MOSS) and I have stumbled across a rather odd issue.
I have a list that has a Lookup column to another list, which works fine. However, when viewing the list and trying to sort or filter, the entries that show up when clicking on the column header are in a seemingly random order. They aren't listed alphabetically, they aren't listed in the order of their IDs. I can't seem to find why they would not just list themselves alphabetically like the other list columns. This makes it hard for users to filter because they have to look through all of the entries in order to find what they are filtering for. I should mention that this Lookup column allows multiple entries, so the sorting option is not available from this menu.
Does anyone know why this list column is behaving this way, and/or a way to revert it back to sorting its filter options alphabetically?