>>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)

It could also be deleted at application startup, then create another afterwards. This way an abnormal end previously should cause no problems in its regard.

>
>Einar