Changing Table Row Order

[David Blomstrom]

I just switched my primary key from a numerical column
to abbreviations, primarily because the latter are
more distinctive and easier for me to work with. The
flip side is that my row order has been turned upside
down.

I made my database in a spreadsheet, with North
America (#1) at the top and Antarctica at the bottom,
and that's how my tables display on my web pages. But
switching to an alphabetical key puts Antarctica at
the top and North America near the bottom.

What's the best solution? Can I retain my alphabetical
primary key but also retain a numerical index, used to
maintain table order?

Thanks.


	
		
__________________________________
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
http://movies.yahoo.com/showtimes/movie?mid=1808405861