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