Sort doesn't seem to work
I have a table (inventory) that has no relationships (yet). One field, "Product SKU", is entered using a value list from a different table "Products". All fields in the initial layout inventory sort just fine. But when I sort using this Product SKU, the order doesn't change. I sort ascending or descending and the status bar says "sorted" but nothing has changed.
Does this have to do with the value list? Thanks