>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

If you do it in code then you could firstly remove field autoincrement attribute by using ALTER TABLE, run your append code and then restore autoincrement by ALTER TABLE again (make sure to set correct NextValue).