>>>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
>
>I would not even try... I would use any other alternative approach suggested...

I will have to go with another route............ this did work, but had some complications in other parts of the code....... too many ways to get snake bit here and not know about it till later.

Thanks!