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

Great sugestion Jim

Einar