Want to keep my old tables id values

[hdesbiens]

Hi

Here's what i wanto to do, i have a table
shipping:
idshipping :autonumber
shippingnumber : a number entered by user
dateshipping
..
..
..

and presently the number used for searching and referencing the shipping is shippingnumber, so i want to keep those numbers and start autonumbering at 100000 thats what it looks like

Shipping new table:
idshipping
12234 (old number kept)
12345
13456
34567
45678
.
.
.
100000 (new record added start at 100000 for now)

i dont know if its clearly explained if not tell me so i will try to explain much better.

I hope you will help me!

thanks a lot

 

[Crowley16]

on the autonumber field, you can specify a starting value...

however would it not be better to just import your old records into this new table?

--------------------
Procrastinate Now!

 

[ceh4702]

We have a database for our school and it is possible to renumber everyone in the person file. Somehow the system knows to rebuild all of the relationship keys that are enforced. I guess it would just set up a temporary renumber table and then rebuild all the relationships one person at a time. I really would not want to try it.

If you do not like my post feel free to point out your opinion or my errors.