> > Ordering? What ordering? Rows stored aren't ordered.
> > Only rows retrieved are ordered.
>
> Correct - thanks for stating what I hoped was obvious :-)
>
> I made a number of assumptions about the OP and one was
> that he needed a two part "key" to manage the ordered
> presentation of information.
>
> So ordering, moveup/down etc is application/presentation specific.

We agree on that then :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com