Thread: Autonumber
View Single Post
  #1  
Old April 26th, 2004, 11:48 AM
Brian C
external usenet poster
 
Posts: n/a
Default Autonumber

I was trying to add a first record to a table called
BOOKING with the primary key defined as AUTONUMBER. I made
a mistake because I needed to put a dummy record in
another table first so no record was added. However when I
then went into the BOOKING table to add the record it was
added with the field set to 2. ACCESS must be saving this
number somewhere and not reseting it if the record is not
added.

How can I reset this value so that the record when added
is given the value 1.

Thanks in advance.