>>Hi Tore
>>
>>>1. If you share a table, and you need an index often, you create an incex in the structural index file by the command Index ox xx Tag yourtag. You do this ONCE, meaning only one time, meaning not two, three or many times, but ONCE. Period, no more discussion here. If you don't understand why, you MUST do some reading in Help. I repeat: you create an index tag ONCE, there is NEVER ever a need to create it more than once. You create index TAGs in only two situations: The first time you see that you will need it often, and after a computer crash.
>>
>>Agreed!
>>
>>>
>>>2. If you share a table, and you need a special index only on rare occations, like every two weeks, you create an index FILE, not tag, for that special purpose via Index on xx to yourtempfile, where "yourtempfile" is an unique file which you usually put on your LOCAL machine, and delete it after you don't need it anymore.
>>
>>I would not do that. Build the tag as in point 1. Leave it there. Use SQL Select to build a temporary cursor using that index tag to optimize. That should be faster than accessing the entire table to do the index.
>
>Oh yeah, I totally agree. I have told that to Mohammad over and over again, but I have given up.
>
>It's like you give someone a Porsche, and he asks you how he can get his horse to pull it for him.

Understood. I'm shocked at the amount of support people are giving him. He doesn't seem to grasp the most fundamental stuff. Some people need more grounding before they can move forward. Without that there will be a lot of instances of the horse kicking the Porsche's front end in.

Clients want qualified people. Qualified people want jobs. We're not helping clients or qualified people this way, IMO.