View Single Post
  #1  
Old July 29th, 2004, 09:33 PM
external usenet poster
 
Posts: n/a
Default negative autonumber

I have an ID field set to autonumber.
The table has a primary key combined of three other fields, ID is not one of
them
The table is being populated via a form where the ID filed is filled
automatically.

I have been adding records for several days and everything was OK untill
today I noticed, that all the records I added today have been assigned the
same negative ID -02
And even one of the records I enetered time ago, changed its ID to -2

What is going on and how do I fix it?

a