Jump to content
Sign in to follow this  
Kevin Cheesman

Remake ID numbers

Recommended Posts

I have been working on a couple of old mailing lists which I have combined into one. Now I need to create a new field that has an incremental ID number, but I cannot see how to get this field populated with new numbers throughout the table. In MS Access, I just created an auto-number field and it would create new ID numbers for the whole table.

Share this post

Link to post
Share on other sites

That can be made in FM too.

1) Show all your records ( eventually sort them in your preferred order )

2) Place the cursor ( in Browse Mode ) into the new field ( the one that must be populated )

3) From menu Records >> Replace Field Contents...>> Replace with serial numbers

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.