Jump to content

Fixing a sort


Tom England
 Share

This topic is 7246 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

This topic is 7246 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.