>>
>>use firsttable
>>use mytable IN 0 && new select area
>>set order to tag ID && where ID is the tag for MyTable
>>
>>will NOT open the index in MyTable because you are still in the FirstTable area. Add a SELECT MYTABLE to the code or load the index when you USE the table.
>
>you can also
>SET ORDER TO TAG ID IN firsttable
>
>Arnon
Another practice when opening new tables is to also set your default index you will be using in that session. like...
use mytable in 0 order *lastname* (if this is an index tag)
use mysecondtable in 0 order (another index tag) etc.
Then just select the table you wish to use. Another useful thing to do is if there are multiple tags you will need at different times, you can do this while staying in you current work area. For instance, if you were in mysecondtable's work area you could stay there and set a new tag in a different table with the following...
Set order to *firstname* in mytable
Do your processing for that particular function and then set the order back when you're done. This is helpful at times when you do not have an environment in reports. This is taking into account that you have some sort of relation between the two or more tables.
My $.02 worth
Jon
Jon Paskett
Microsoft Certified Systems Engineer
We all have to start somewhere...
Sometimes over again!