>>Tommy, never tested, never used (I even don't want to post this), but I am curious if this could works (so you are my experimental rabbit :o))))))
>>

>>*** SET all relations between tables
>>SELECT YourMainTable
>>INDEX ON UPPER(Drugs.DRUG_NAME) TO TemIDX && Must be IDX file
>>

>>Then use that index to chnage orders. As I said, not tested at all and I don't know which problems this could cause.
>
>I will give it a try. Hopefully, no unseen complications from this.

I used this technique a lot... until FP2.0 :).

The only trouble is if you keep the temidx.idx file around and try to open it when your drugs table isn't open (you get a "variable not found" or some other error message), or if it's open but not ordered and related into (your navigation is off - can't remember exactly how).

The other trouble is the multiuser issue - if two of your users try to create the same idx file at the same time, they'll get some error message (maybe "file is in use by another" or "cannot create file"), so you'd better create it under a unique name, and/or on your user's private temp directory. And don't forget to delete it afterwards.

I still don't recommend this. It will work, but... I'd rather go with a writable cursor and some code to do the updates.