Thanks - that certainly was simple enough!!!!

Gaylen


>See SET AUTOINCERROR Command.
>
>>In trying to move some test data from production to test I tried to use "append from production". I am using an autoincrement field for id and it doesn't like the "append from" saying it is read only.
>>
>>I know I can scan the table and drop the values each field or can use SQL "insert into test(field1,field2) select field1,field2 from production) " but both require a listing of fields. Since this is a table with many many fields, is there a simplier way to move the data between tables with auto increment fields.
>>
>>
>>Thanks
>>Gaylen