If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto number field
This really isn't what autonumbers are for. The only thing they do is to
provide a unique set of data - eg. so you can identify a record, etc. It is a BIG mistake to use them for anything other than as a unique reference. I suppose if you really wanted to you could just create a record then copy it and paste append. Then copy the 2 records and paste append then the 4 records etc etc etc until you have 19999 records but this is just silly Why not not just add a number field to your table add 19999 into it and then auto incremet this field (use a max lookup +1). Much better. -- Wayne Manchester, England. "blake7" wrote: Hi All, I would like to know if it is possible to renumber an auto number field, I know this is scoffed upon and goes against the principals of database management, but i would really like to know if it can be done. I am currently using data imported from an excel sheet which my company uses for a tracking system, I intend to start a fresh table when I have finished writing and testing the database so would like this new table to start at a number beyond the current excel sheet. What is the easiest way to start the new table at 20000 Thanks |
Thread Tools | |
Display Modes | |
|
|