Thanks to all of you ...
>Raymond,
>
>Alltrim in indexes is not only a bad idea, it will lead to incorrect results. Alltrim would create variable length indexes, which VFP doesn't support. It pads the end of the index key with spaces to make them all the same length.
>
>As far as incorrect results:
>
>You have record 1, with parent key value "10" and child key value "1"
>You have record 2, with parent key value "1" and child key value "01"
>
>If you trim these columns and concatenate, both records would have the exact same value, "101". Yet they are obviously not the same records.
>
>Pf
>
>
>>While building some compound indexes like the following ALLTR(A)+Alltr(B) name mytag, I found that I can not relate two tables together on the compound index. The table joins together just fine using the two indexes individually, but not when I concatenate them together. I went so far as to copy the concatenated values from one table to the next, reindexed and still the tables will not relate together correctly when the values are concatenated and a relation is set with the compound value.
>>
>>Anyone have a clue what I'm doing wrong?
>>
>>thanks