Whenever I create a new record each file increments by 1. This shows how many companies I have.

EG

1

2

3

But say that I delete number 2. How can I then create another company so that it automatically numbers this as 2 and not 4?

Thanks in advance if someone can help.

What you are trying to do it STRONGLY not recommended to be used as a serial number. You should always use FM's built in serial numbering. However, if you still keep each comapny with its own UNIQUE ID via FM's serial numbering and for DISPLAY purposes only you want to do something like you asked for, try taking a look at this thread.

You can use the [color:blue]Replace Field Contents in the [color:blue]Main Menu >> Records >> Replace Field Contents, or the [color:blue]Script Step "Replace Field Contents" to do this. this will do is to renumber all of the "Found Set", so be sure that you have "All Records" as your found set.

However.....

I don't recommend doing this without asking you some questions.

What is the purpose of this Field?

Do you use it in calculations, or relationships?

Have you looked at the Get Functions. Search the Online Help (with FileMaker open) for Functions reference (alphabetical list) > Get functions, there are a couple of them that can be very useful in identifying a record, found set, and total records...

HTH

Lee

Hi Mr_Vodka,

I Agree with you. I had my post ready to go, and got interrupted a few times before I hit the Add Post button.

Since there a few other things mention in my post, I'll leave and apologize for any duplications in my response to yours or your link.

Lee