AnsweredAssumed Answered

inserting primary key serial numbers into old data with empty field?

Question asked by DonorTracker on Apr 27, 2009
Latest reply on Apr 27, 2009 by Jade

Title

inserting primary key serial numbers into old data with empty field?

Post

I imported a bunch of check_book register data into FMPro 10.  The original data did not have a unique serial number kp field.

 

How do I get a unique serial number into the old data?  (I don't want to re-import it.)  New records are creating the kp serial OK.

 

My current settings on the field are thus:

 

_kp_check_register_id Text    Indexed. Auto—enter Serial. Can't Modify Auto. Always Validate. Required Value, Unique

Outcomes