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

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

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

thanks.