>Several tables are related in a form. I'd like to order the main (navigation) table by a description field that is in one of the reference tables without using views. Is there a way to create a temporary index that will just disappear when the tables are closed, eliminating future problems if the application should have an abnormal ending?
>
>TIA,
>
>Alex

Try using: INDEX ON eExpression TO IDXFileName

IDXFileName can be anything and will have to be deleted after use (unless you want to keep it around)

Einar