I am creating a new table with the first field being 'ID' with a type of 'autonumber'. Their are many other fileds in the table, all containing data.
How can I get the ID of the first record added to be something other than 1, such as 1000. Second ID would be 1001, then 1002 etc..
I know I can do this by creating the new table, adding 999 records and then delteting them all. I was hoping there was a simpler way since the real number I want as the first ID is 11,000,000.