How to populate new key field?

[Darren Emery]

I searched for this one - I know it must have been asked before, but no luck. Chances are, I'm not using the right terminology.

I have a file of about 10k dwelling units that need to be tracked for yearly inspections. Each dwelling unit has a unique license number which I have used as a keyfield.

I just realized that I need an additional, more permenant number for the key - the license number will change if the property is sold.

So - I need to create a new serialized dwelling unit ID number. My question is: how do I create this field so that FM will automatically populate this field, rather than having to manually enter the numbers?

Thanks in advance for the help!

[TheTominator]

field Options...

Auto-enter tab

Serial number

[Darren Emery]

Unless I'm missing something - this only enters the number on new records created past this point.

I didn't ask the question very clearly - I'm looking to go back and fill in ALL of the records to this point, and any new records.

[Darren Emery]

Ah.... found it.

The all powerful "replace" function.