Failure to sort...

Discussion created by user28097 on Nov 3, 2013
Latest reply on Nov 3, 2013 by user28097

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?