First Available Unique Number

[Gilmoro]

I'm terrible at Filemaker's calculations. I'm needing to auto-enter a serial number, but it needs to be the lowest available unique number. So, say for example, a record gets deleted, I would like the next new record to get it's number.

What would this calculation look like? Say we have a library with call numbers 1-10 and the record with call number 5 has been removed. The next new record needs to get call number 5 instead of 11.

Thanks for any help you guys can give!

[Raybaudi]

Hi

take a look at this:

http://fmforums.com/forum/showpost.php?post/233683/

[Gilmoro]

Thank you so much!

This worked perfectly!

[comment]

No warning?

http://www.fmforums.com/forum/showtopic.php?tid/191695/post/273995/#273995