How do you set the sorting order on a form that has a database control toolbar on it (Top, Bottom, Next, Prev)? My form has one main file and several associated files linked by relationships. The form has two pages in a pageframe... page1 is the detail, page2 is a grid style list.

The primary key on the main file is a unique ID field. I have another REGULAR key setup on a date in the file.

I tried modifying the DE for the main file and selecting the date key under the ORDER property for the cursor.

That doesn't seem to work. I also attempted to analyze the order that it does list in to no avail... it's not in any sequence I can tell what so ever.