Hi All
I've come across an issue that I can't figure out. I have a database that is accessible to my entire group but today I went to add a new record and it is duplicating the PK Autonumber field and then saying there is duplicates in the Primary Key field. It won't allow me to add any new records. I'm at AutoNumber 59 but when I add a new record now it assigns 13 which was used some time ago. Then the message saying I've got a duplicate in the primary key and you can't save this record at this time message comes up.
Any Idea?
Seriously stressed.
Tammy