Help with Changing Default Sort code

[Cevelctq]

I am trying to set the default sort code to something other than the primary key. Example- Book Code is Primary Key but I want the table to be sorted by Title. I have went into properties and used the Order BY property and typed 'Book.Title' however when I view the datasheet, Book Code is still the 1st column??? Is it still being sorted by Title??

Any help would be greatly appreciated

 

[flixx]

To Cevelctq:
Just a suggestion, try creating a query with your table in it and then
add the fiels you want , and under the Title set sort order to ascending
or descending and that field only. Flixx.

 

[Cevelctq]

Thanks, that helped me figure it out