View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 11:32 AM
bissatch@yahoo.co.uk
 
Posts: n/a
Default Auto incremenet primary key field starting at 1001 ... (1001, 1002,1003, ..)

Hi,

Is it possible when creating a table to have the auto incremenet field
start at, for example, 1000 instead of 1. I would like to have a table
called orders and want to use this number as an invoice code. Cheers

Burnsy
Reply With Quote