Z
Zodiacal
how can i set the starting incremental number for my autonumber field to
50000?
there are allready records in my table.
the autonumber values were from a field that was set to increment randomly
so i have -'s. (i got it back to incremental by appending to a second table
with a new autonumber field)
then i did what the help file said to set the current starting point for a
incremental filed and it doesn't work. what i did was:
i appended a 50000 value from a second temp table and it just ignores it.
its staring my new records out at -43000. how can i get it to start at
+50000?
50000?
there are allready records in my table.
the autonumber values were from a field that was set to increment randomly
so i have -'s. (i got it back to incremental by appending to a second table
with a new autonumber field)
then i did what the help file said to set the current starting point for a
incremental filed and it doesn't work. what i did was:
i appended a 50000 value from a second temp table and it just ignores it.
its staring my new records out at -43000. how can i get it to start at
+50000?