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.
>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.
Best Regards
Don Simpson