Missing PK Serials

[Jeffrey Holzenthal]

I have imported data into my table and did not initially use Auto Enter Serial. Now I wish to generate these unique serials, but the records already exist. The PK (serial) field is currently null. Is there an easy way for me to easily generate a unique serial into the PK field?

Thank you!

[Vaughan]

Yes... click into the pk field, then use the Replace Field Contents command and specify serial number.

Note that (1) the "Prohibit modification" option must not be selected in the field definition; and (2) if related records already exist then the new serial number probably won't match the old, and all the children will be mixed up or orphaned.

[LaRetta]

And be sure all records are showing to begin with. I made THAT mistake once. :smile2:

[Jeffrey Holzenthal]

Thank you. That worked perfectly!