Autonumbering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I imported a new table from Excel. I chose my own primary key, which is my
ID number field. How can I get Access to generate the Next ID number? I
want to keep my original ID numbers.
 
This is best done by keep the next number in a seperate 1
record, 1 column table.(real small table) For a new record
the code simples grabs the sole next number stored in this
table. When the record is added to the database, the next
number table is update by adding 1 to the record that is
there. this is basicly the way access handles autonumbers
except you can control it a tad better.
 
Thank you for replying. I understand creating the small table, but the rest
I don't understand. What do you mean by the "code"?

Thanks
 
hi again
code is any programing language. VB is one of then
another word or code would be prgraming.
 
Back
Top