>Having being used to generating unique reference fields in the past i decided to use to auto inc value for a particular project. I now want to append the contents of one table into another but i still want to keep the original unique reference no. When I append or scatter/gather foxpro will generate a new one
>
>Many thanks for any help

You can set

CursorSetProp("AutoIncError",.F.)

then can append the data. But that ignores the values inserted and uses the autoinc counter instead, so you need to alter the table, then alter it again with a good nextvalue.

Bye, Olaf.