Help!! Problem with primary key and not creating new records

[msmithtlh]

Something has gone wrong with my primary key.

I have a main table, with an autonumber primary key. I also have a related table, which inherits the main table primary key when a record is created. They are separate because many records only have data in the main table, but others have many more fields of data. This has been working fine until this morning.

I have a separate forms to add records, and a different form to update records. Last Friday I merged in some of the data which only has data in the main table. I think this must be related to the problem we see this morning.

The highest record number - looking straight at the table is 1280, but when I go to the add form, it brings up record 731 (with the data) and although I, of course don't want to save it, when I close the form, it pops up the message that I can't save the record because it would create duplicate values.

I have worked with Access for many years and have never seen anything like this. Thanks in advance!!!

[msmithtlh]

I need to clarify one thing. There are gaps in the record numbers. I took a copy and started adding records, it was using the "unused" numbers, but then when it got to a number that had been used, it still tried to use it again. Is there a way to give the autonumber a beginning number?

[msmithtlh]

I need to clarify one thing. There are gaps in the record numbers. I took a copy and started adding records, it was using the "unused" numbers, but then when it got to a number that had been used, it still tried to use it again. Is there a way to give the autonumber a beginning number?

I finally fixed it by renaming the table and running a make table query to replace the old data. Scary!!