messed up my database

[drshahriyar]

Dear users
i desperately need help. i was playing with briefcase function when i accidently deleted the master copy. there was no back up. i created a new master from replica. now the problem is that my forms are generating random numbers in autonumer ID field. i cannot change it to increment value. is it possible someway to change it to increment value. i have stopped using briefcase function and my database is limited to 1 computer now.

thanks

 

[boblarson]

Databases that use replication will use RANDOM autonumbers, even with a Master copy and you really shouldn't be using an autonumber for meaningful numbers as they are ONLY guaranteed to generate a UNIQUE number, not necessarily in order.

If you need incremental numbers you should create your own "autonumber" by utilizing DMAX and incrementing.