Bump the key code up by `1 for new recs w/o using autonumber

  • Thread starter Thread starter cheswyck
  • Start date Start date
C

cheswyck

BACKGROUND: I had a table with autonumber key. Then I had
to export it an Excel format so others could make changes
and deletions. When I tried to import the file back into
the access file I got a message saying I cant load a
number into an autonumber field. I have to keep the
existing values so I deleted the records and changed the
key to 'numeric' and loaded the excel file.
PROBLEM: Now when I add another record I have to add '1'
to the last key number. How do I do that automaticly?
Can I use some kind of (previous/highest value function
+1)?
 
Back
Top