Sort large amount of records on opening db
I have about 20,000 records in my database. When I open the DB, in list view, the oldest record appears at the top of the list as this has the lowest number. However, i want the highest/most recent number to appear when I open the db. If i apply a sort script on open, it takes afew seconds to implement, which is annoying. What can i do ? Howabout saving the sort order from the last person who closes the database?