Remake ID numbers

[Kevin Cheesman]

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.

[Raybaudi]

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

[Kevin Cheesman]

I've only just seen your reply. Thanks for your help!

Far better way than MS Access too ???

Edited September 26, 2007 by Guest