reset auto

L

lane55

When I reset autonumber. I delete autonumber from table,
save table without autonumber. Then open table and add new
autonumber field. Perhaps its a bad shortcut but, it works
for me.
 
J

Jeff Boyce

A downside to what you describe would be if any related (child) tables had
the original autonumber values as foreign keys. If you wipe out the parent
table's autonumbers and create new ones, this orphans the children ... or
worse! If you have a match between a (newly) autonumbered parent and the
same value as the foreign key in the child table, is it even the same
parent?!
 
Top