i am setting up a database, just a simple one with names addresses etc of companies we deal with. The problem I have is that i want the DB to be sorted in alphabetical order of the companies' names. Sounds straight forward, I have setup a script to sort on opening.

The problem is if somebody does a find then does show all, the records return to the order in which they were added to the databse. Is it possible to lock a sort order so that they are always in alphabetical order???

NB. Nobody will need to sort them any other way.

thanks

quote:

---

Is it possible to lock a sort order so that they are always in alphabetical order???[/QB]

---

The only solution I can think of is to script everything. In your case, you would have one script that performs the Find and another to restore the Sort order.

Your Find Script could be as simple as:

Enter Find Mode

Pause/Resume Script (indefinitely)

Perform Find (do *not* restore requests)

Perform Script [sort Script]

Go to Record [First]

Hope this helps!