G
Guest
thanks to the knowledge i have gained by lurking on this forum, i have
managed to untangle a database now formerly consisting of one giant table and
have made it into something reasonably normalized. However, just recently
one of the tables has started assigning new records autonumbers from the
middle of the deck -- those being, numbers it's already assigned, which sets
you up to get that "duplicate record" error.
surgically altering it in the table does not work either as it tells me it's
bound to autonumber ID field and i can't alter it (SOL)
Short of creating and obliterating new record after new record until i run
it out to the next truly new number, how can i fix this?
Querent
managed to untangle a database now formerly consisting of one giant table and
have made it into something reasonably normalized. However, just recently
one of the tables has started assigning new records autonumbers from the
middle of the deck -- those being, numbers it's already assigned, which sets
you up to get that "duplicate record" error.
surgically altering it in the table does not work either as it tells me it's
bound to autonumber ID field and i can't alter it (SOL)
Short of creating and obliterating new record after new record until i run
it out to the next truly new number, how can i fix this?
Querent