I didn't add a unique "serial number" for each record in a solution I've been working on for some time. But now I find I need one after all. I'm 2400+ records into the db. Is there a way in FMP6 to populate the existing fields without having to enter the information in manually? Then I'd lock up the field so user can't enter/input/change and let the automated serial number work when each new record is created.

But was needing to know if there was a way to automate the population to save an hour or two of manual work.

Thanks! :

Is there a way in FMP6 to populate the existing fields without having to enter the information in manually?

Yes - use the Replace Contents command/script step.

Goodness, when I came here for help, little did I realize that it would be the single easiest solution I'd ever been advised of to implement. That was incredibly painless! I can't thank you enough. Even after all these years and the pains of going through numerous FMP versions till I stopped at v6, nice to see that some things can, after all, be delightfully easy.

All my records now have a unique #. Neat. <g>

Thanks! :