auto-enter (serial) on #, selecting deleted value

[axishift]

Hello,

I just started learning filemaker yesterday and its really fun.

I downloaded this great db from filemaker.com and i try to inegrate its auto-serial options on my current work.

Now i wonder, i created a new data the serials makes it #1 and new data #2 and so on. But when i deleted the data it still increments and doesnt use the vacant serial #, can i make filemaker to look for that vacant # and use it, before moving on and incrementing #'s again.

thanks,

Louie

[Lee Smith]

Hi Louie,

Look at the section titled "serial numbers" in the On-Line Help. Although I have used the replace as described, be careful about doing this with any serial numbers that involve relationships.

HTH

Lee

[Mike D.]

My opinion is that numbers are cheap. They go on forever and don't cost you a dime. Trying to re-coup unused serial numbers will definitely cause you problems in the future, especially as Lee pointed out, if you use them in a relationship between files.

Mike

[axishift]

thanks.