I don't know what you mean. But please, please read my message, and do it more than once.

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.

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.

>hi,
>all tables i use is shared tables.
>
>i mean how i can use all tables via main program,
>and how i can call any table via any form .
>
>thanks alot. if End of discussion or not.
>
>>Analyze your application, and use cursors whenever possible. If main2 is shared, you use index tags, and create it only once, period!!!!!!! If that's not possible, you have started in the wrong end, and must reconsider your design. End of discussion!
>>
>>If main2 is NOT shared, store it locally and use it exclusive always.
>>
>>>hi,
>>>2.thank you, ok , but my table main1 need to creat index for every new main1
>>>maybe i need to create main1 more one time daily,
>>>
>>>2.some thing else i need your advise or your way to use all tables as excl off , when many users use my project (mean sharing).
>>>somthing as under, and how i can call any tables to work area at any form or application i create
>>>

>>>close all
>>>*SET SAFETY off
>>>SET EXCLUSIVE on
>>>USE main1 IN 0
>>>INDEX ON flag tag FLAG
>>>USE main2 IN 0
>>>USE trans1 IN 0
>>>
>>>

>>>
>>>thanks alot.
>>>
>>>
>>>>Mohammad, remember Help is your friend! To create an index tag, you must use the table exclusive. But, you normally create index tags only ONCE, there is no need to create an index tag oer and over! If you need a temporarily index, you don't use the TAG option, you just index to a temp file, and delete the temp file afterwards.
>>>>
>>>>>hi all,
>>>>>
>>>>>
>>>>>i try as under , igot error message file must open excl
>>>>>

>>>>>SET SAFETY off
>>>>>SET EXCLUSIVE off
>>>>>SELECT 1
>>>>>USE main1
>>>>>*use main1 in 0
>>>>>INDEX ON flag tag FLAG
>>>>>

>>>>>thanks