>Here's the deal:
>In VFP9, I am attempting to append a cursor into a table with a compound index as follows:
>
> lcTempCatgFile = DBF( "__NewPartCtg" ) && Cursor to append from
> SELECT PCategories && Table to append into
> APPEND FROM &lcTempCatgFile
>
>When attemping to append, the following error is presented:
> "Error building key for index "p.\partctg.cdx" TAG "Pctgkey"
>
>When I click on help, it brings me to (Error 2199) "Error building key for index "Name". I don't see the problem. I do not get this error in VFP 8.
>Is it because the field order in my cursor is different from the table I'm appending into (File_Date field is not in same location)?
>
>
>The cursor layout is:
>P_ID C(03)
>PARTICPCTG1 C(10)
>PARTICPCTG2 C(10)
>PARTICPCTG3 C(10)
>PCTGDESC1 C(50)
>PCTGDESC2 C(50)
>PCTGDESC3 C(50)
>FILE_DATE D(08)
>
>
>The table I want to append into is in the following layout:
>P_ID C(03)
>FILE_DATE D(08)
>PARTICPCTG1 C(10)
>PARTICPCTG2 C(10)
>PARTICPCTG3 C(10)
>PCTGDESC1 C(50)
>PCTGDESC2 C(50)
>PCTGDESC3 C(50)
>
>The index entries are as follows:
>PCTGKEY: P_ID + PARTICPCTG1 + PARTICPCTG2 + PARTICPCTG3
>PARTICPCTG: PARTICPCTG1 + PARTICPCTG2 + PARTICPCTG3
>
>The index is not set to either tag while attempting to append.
>
>Also, please don't cringe when I say this, but SET ENGINE BEHAVIOR is set
>to 70 for backwards compatibility.
>
>Any ideas?

A duplicate key ?