>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...
>
>>Don,
>>
>>If you want to corrupt your tables, this is the simplest way to do so :)
>>
>>Is p-View not an option for your?
>>
>>May be you can just set relation between two tables and don't use indexes?
>>
>>Thanks in advance.
>>
>>>All,
>>>
>>>I have tables in which I want to have an index containing fields from another table.
If it's not broken, fix it until it is.
My Blog