>>My current equipment form data environment has 13 cursors, four of which we would want to sort (or index on) the main equip table. My experience with parametric views is that the complexity of the view increases exponentially with the number of cursors used.
>>
>>However I will give it a try.
>>
>>I do not see how I would corrupt data by indexing into temporay files, which are thrown away.
>
>The possible scenario: you create an index on two tables. When VFP hangs and you have to kill it. Now you have corrupted table, which you can not open without opening another first and establishing relations...
OK I see. I am trying to use local views, without much success.
Thank You
>>
>>>Don,
>>>
Best Regards
Don Simpson