Multiple Criteria Sort doesn't work properly
I am using Filemaker Pro 11 and have a database ending in .fp7. It was originally created in fp5. I have done this kind of multiple criteria sort a million times with this database, but after upgrading to FM 11 the 2nd criteria doesn't work correctly. A single sort does fine, but when I add the second factor, several of the items in that list are out of order. Most of them are fine, but there are several names in each category that are not alphabetical, and they are at the end of the list. Any ideas what's wrong?