Sort value list: what am I doing wrong?

[aharown07]

I have layoutA for tableA related to tableB with a cartesian (by their respective uniq id's).

On layoutA I have a field set up to display a dropdown using a value list.

The value list is supposed to come from a field called AcountName in tableB.

In tableB, these Account records have a SortOrder field, each with a unique character.

In the relationship, I have tableB set to sort by that SortOrder field, but when I use the dropdown on LayoutA, the AccountName items do not appear in the sorted order.

What am I doing wrong?

Now I know I can pull the SortOrder field into the valuelist as well and tell the value list to sort by that field, but that disables Auto-complete and I'd kind of like to keep that. Besides, shouldn't the value list sort according to the relationship I set up? I guess that's what's bugging me most.