>Robert,
>
>>table1
>>fld 1 = custno
>>fld 2 = partno
>>
>>table2
>>fld 1 = custno
>>fld 2 = partno
>>
>>need a set relation on custno+partno into table1
>
>Assuming that both fields are Character-type, you would do this.
>
>USE table1
>*INDEX ON custno+partno TAG custpart
>SET ORDER TO TAG custpart
>SELECT 0
>USE table2
>SET RELATION TO custno+partno INTO table1
>
>However, if the fields are numeric, you must convert them to character first:
>
>USE table1
>*INDEX ON STR(custno,6)+STR(partno,6) TAG custpart
>SET ORDER TO TAG custpart
>SELECT 0
>USE table2
>SET RELATION TO STR(custno,6)+STR(partno,6) INTO table1
>
These will not work:
The problem is with SET RELATION TO custno+partno INTO table1.
It can not find partno.