auto number script for existing records?

[shaolinstyl]

I need to add an auto number for each existing record in an existing database, (for some reason it doesn't have any identifying ID #) to deal with exporting. I need some kind of script to add a unique number to each existing record.

I know how to do this for all new records, but this doesn't help me. Do you know a simple script (perhaps with a loop) to do this?

Thanks.

[dspires]

Im afraid that it's way easier than you think.

If you have a field, called index for instance, simply click in it, select "Replace" from the Mode menu and select the serial number option. (This works on the found set so be sure to have found all records first)

[shaolinstyl]

Thanks,

This may be a really stupid question but where do I find the mode menu?

[Chuck]

In FMP 5 Replace is on the Records menu when you're in browse mode.

Chuck