Autonumber Field - Duplicating Numbers

[sgtSortor]

I have a table with a Key Field which is Autonumber,

- Field Name: SeriesID
- Field Size: Long Integer
- New Values: Increment
- Indexed: Yes (No Duplicates)
- Text Align: General

I am appending new records into this table and it is duplicating the SeriesID.

last record was:
SeriesID Series AuthorID
70 The Well Pleasured Series 18

Appended New Record:
4 Newest Record 18



Obviously there is already a #4 record and it won't let me create this record. I don't understand why it's not just automatically putting 71 as the next record ID.

Once, I appended two tables together and it put both tables together and had many duplicates. I can't figure it out. I also can't get it to do this again, but it is still not creating unique id's for new records.

HELP!

 

[georgedwilkinson]

Try this article:
http://allenbrowne.com/ser-40.html

 

[dcb]

If you say you are appending the record I assume that you are doing a "append" query - Looking at

Appended New Record:
4 Newest Record 18

Your query would be :

Insert into tbl_Unknown (SeriesID,Series,AuthorID) Values (4,"Newest Record",18);

You are not allowing the Engine to generate the ID as you have specified it in the query - Just leave it out

Insert into tbl_Unknown (Series,AuthorID) Values ("Newest Record",18);