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.