Sorting slow down

[buckbuck]

When my database loads it is slowed down by an info window telling me a sort is in progress. Does anyone have a suggestion how to manage this situation. I want to control the sorting and summarizing function of my database so that it is not slowing me down so much.

[LaRetta]

Hi buckbuck,

It is best to open a file onto a null layout (with no fields and even taking it further to no records). Only switch to that (list?) layout after you produce your found set and sort it (on an empty layout based upon the same table occurrence as the list).

Set your opening layout in File > File Options which uses the OnFileOpen trigger. :^)