Jump to content

This topic is 6029 days old. Please don't post here. Open a new topic instead.

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.

Link to comment
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

Link to comment
Share on other sites

  • 2 months later...

This topic is 6029 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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