Creating a Unique ID#

[bob sherman]

I have inherited 2500+ files and need to place a unique ID# in each. I have created the ID# field and just need a looping script that will place an ID# number + 1 in each successive record. Is there a way? Thanks.

[Lee Smith]

If it is a one time action, use the Replace in the Menu. Put your cursor is in the ID# field, go to Menu - Records - Replace (Cmd = on a Mac).

The menu is pretty easy to follow, but if you need help, let us know.

Lee

[bob sherman]

Thanks Lee. Yes, I am working with a PC using FM 6.0. I can go to records > replace which will place an ID number + 1 in each record. But with 2500 records I need a way to automate the process. Can this process be looped?

[bob sherman]

Thanks Lee. Yes, I am working with a PC using FM 6.0. I can go to records > replace which will place an ID number + 1 in each record. But with 2500 records I need a way to automate the process. Can this process be looped?

[MeltDown]

If you find all of your records first, and then do what Lee Smith recommends, it will enter a new serial number in each of the 2500+ records - no looping is required. Hope that helps!

[Lee Smith]

The Replace (second option) default with number 1 and increments of 1, which means the first record in the "Found Set" will be 1 and each record after will have a higher number by 1. So, your records would have the numbers 1 - 2500. You can also change the starting number to A0001 and then your numbers would go like this, A0002, A0003, etc., .. A2500

After you have made the replacement, go to the options for the field and use the Auto Enter option.

HTH

Lee

[bob sherman]

Thanks. It worked the second time. And the field is now set to auto entry.