See ADDITIVE clause.

>
>I have three tables. I want to relate one table with the other two tables at once using two different indexes .I can't let this work:
>
>

>use MyTable1 in 0
>select MyTable1
>index on special to special.idx
>
>use MyTable2 in 0
>select MyTable2
>index on special to special1.idx
>
>use MyTable3 in 0
>select MyTable3
>index on specialext to specialext.idx
>
>*** I want to relate MyTable1 into MyTable2 as well into MyTable3
>*** MyTable1 has the following fields : special and specialext and some other
>
>select MyTable1
>set relation to special into MyTable2 && relation with MyTable2 established
>
>***Now I want to establish a relation with MyTable2 based on specialext,
>***how do I do this without losing the relation with MyTable2 ???????
>
>

>
>Thanks in Advance.