Prompt Order

[stewm]

When you create a prompt you can sort in the following ways:
Ascending
Descending
As Source

I have an Oracle indexed table called tracking_events. When I choose Ascending and Descending it applying it to the order. However when I choose As Source it appears as Ascending. When I do a simple select * from tracking_events in the database the order is how it was entered into the database. Should the As Source just be a simple select * from tracking_events or does it automatically sort Ascending when the referenced data source is indexed?

I wanted the more commonly used options on the list to appear first or as they are displayed in the select * from.

Thanks,

Mark