>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