Primary Key

M

Mat

Hi

How can you set a primary key number (autonumber) to start
from a particular number - eg "10000"

I have invoices issued from an old accounts package - and
am creating a new database to replace it, but do not want
to duplicate old invoice numbers. I seem to remember in
the past a way of setting this but cant remember - any
help please ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No Primary Key! 4
primary key - concatenated or autonumber? 6
Indexing Issue 3
Primary Key start number 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Relationship with a Primary Key? 4
Primary Keys yes or no? 8
Create invoices/cheques for batches 5

Top