inserting primary key serial numbers into old data with empty field?
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