AnsweredAssumed Answered

Resetting Auto Generated Serial Id Numbers

Question asked by mukelly on Nov 30, 2009
Latest reply on Nov 30, 2009 by mukelly


Resetting Auto Generated Serial Id Numbers

Your post

I am using Filemaker 8.5 on a Mac OSX version 10.5.8.  I am I guess a novice in terms of creating scripts and such but I learn quickly.  


I have a database of artwork that automatically assigns an id number with eachentry. I have gone back and deleted some entries and this deletes theid numbers as well.


I do not know how to reset the serial id function so that the numbers are consistent. For example, I do not want the auto assigned id numbers to jump from 141to 160 just because I no longer needed the records in between.  


Is therea way to reset the automatic generation of serial id number so that itdoes not skip numbers when an entry is deleted?  So if I delete entry 135, 136 will become 135.  Is this possible, I can't figure it out.  


Thank you in advance for your help!