Lisa I don't know what the problem with your table is, but here is what I would do to try to nail what is happening.
I would open the table that is in question and manually add records by pressing ctrl+Y until the cid value "00000a" is next to come and see what is happening.
Maybe this will put some light onto your trouble.
Andy
HI-YO SILVER AWAY!!
The Lone Ranger, The late Clayton Moore R.I.P.
I am a fool!