Serial Number field not sequencing correctly?
Why is the Serial Number field not sequencing correctly - using FP11 on Mac?
I have created 3 student/contacts databases & added Student ID number to them all, the serial number appears correctly in each new record as it is added but the number sequencing jumps around eg 1001, 1002, 1003 then straight to 1010, 1011 or straight to 1077.
I have created the field with Auto-Enter Serial - via Serial Number, On creation with an increment of 1. Can you tell me what I have missed?
Thanks for all your assistance, much appreciated.