Thanks, everyone, for your replies. Under the circumstances, I think I will convert the autoincrement type to a character field and manage with an insert proc as I have some other sync issues to factor in as well. As these things go, the scale of the project is increasing, so a quick, simple solution like autoincrement doesn't make much sense anymore.


>>I'm copying table contents from one file to another and ran into an error while copying a table with an autonumber field. It says the field is read-only (which makes sense, I guess), and won't copy the records using an append from statement. Is there a quick/standard way to get around this? I know I could do a file copy, but was hoping to just pull records as needed from the other table.
>>
>>As always, thanks in advance.
>
>The trick is to eliminate the autoinc fields from the amount copied over.
>To be able to use Fieldlists in xBase and SQL I build them into a variable
>and makroexpand that for SQL or add as Fieldlist for xBase.
>
>HTH
>
>thomas