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

Thanks!

Tommy