>>>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
>
>Thanks Einar.
You are welcome

Einar