Autonumber not unique after insert query

[kaiana]

Hi,

It has taken me some time but I have managed, (with the helpful suggestions from tek-tips), to get an insert query working well pulling data from old backend and appending to new backend. Then I find that the autonumber is disregarding the numbers that are in the field and starting at 1 again, of course creating duplicates which it won't allow. Any suggestions would be appreciated.

 

[MichaelRed]

You cannot "copy" a value into an autonumber field. the Help docs are quite clear about this. If you want to copy the records and retain the old 'autonumber, the dest table field needs to be long int.



MichaelRed
m.red@att.net

Searching for employment in all the wrong places