Hello Hilmar,

I have never used views. If you don't mind could you give a workable example or link? I will look myself at some examples in vfp help.

Thanks.



>>Hello All,
>>
>>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.
>
>If you want to make more than one relation from the same table, Table1, into two or more other tables, use the ADDITIVE keyword:
>
>

>...
>select MyTable1
>set relation to special into MyTable2
>set relation to special into MyTable3 ADDITIVE
>

>
>Note that "special" is a field, not the index. In other words, it doesn't matter if Table1 is indexed or not.
>
>If it is for a report, it is easier, IMO, to use a query that combines the data from the different tables.
>
>If you need to change the data, you might also consider a view (similar to a query, but updatable).