On 21/06/2009 18:57, Michael Fraley wrote:
> How can I change the default data sort for a table? When I view the data
> in the selected table, it always opens a spreadsheet view sorted by the
> primary key. In this case, the primary key is a one-up number and a more
> useful sort is the name column. How can I have it default to sort by
> name rather than primary key?
When you open the data view window, go to Tools -> Sort/Filter, and
select the column by which you want to sort.
Also, you could open a query window and do
select * from my_table order by desired_sort_column;
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------