Raymond,

I wanted to make sure you got the whole picture on indexes.

First off, FoxPro ignores all types of trim functions in indexes. All index expressions are fixed length in order to allow for the maximum values. Any type of trimming is useless.

Also, when you're making that compound field, don't trim or you'll find that Ted Dyster and Teddy Ster will look like the same person! Stick with the whole field(s) - INDEX ON LastName + FirstName TAG WholeName.



>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