This looks simple -- I am selecting to sort records on a text field that contains either "T" or "F". But the sort option does nothing. The records remain in their original sort order with T's and F's in no particular order. I can sort the same records by another text field (last name) and that works.
This table was imported from a FoxPro table where the field type was a "logical" field which means it contained a logical true or false. Apparently FileMaker converts these to text and uses the letters "T" and "F" instead. Not sure if that's related.
Any reason that sorting on a particular field would have no effect?