[FP5] Random sorting of records

[Matt Klein]

I am having a problem at one of my customers. They are set up in a FileMaker Server environment with up to 10 workstations. The problem is that at random times one of the workstations(not the same one everytime) will get a "Sorting" dialog box when they are not on a screen that has a sorted portal and are not running a script that performs a sort. When this random sort dialog appears, it appears to be sorting all the records in one of the files. Also, it basically ties up the other workstations when it does this. The other workstations get the squiggly line.

Any thoughts.

FileMaker Version: 5

Platform: Windows 2000

[-Queue-]

You don't need a portal for this to happen. If you're displaying one related field whose relationship has a sort associated with it and there are many related records, this would be expected to happen, especially if there is a multi-level sort or one or more of the sort fields cannot be indexed.