Access autogenerated columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1124152%22%20slang%3D%22en-US%22%3EAccess%20autogenerated%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1124152%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20central%20table%20with%20an%20autogenerated%20key.%20The%20key%20has%20only%20be%204%20digits%20for%20the%20last%207%20years.%26nbsp%3B%20It%20is%20now%20generating%20a%20key%20of%208%20digits.%20How%20do%20I%20adjust%20the%20generator%20to%20revert%20to%20the%20next%204%20digit%20number.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1124152%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have a central table with an autogenerated key. The key has only be 4 digits for the last 7 years.  It is now generating a key of 8 digits. How do I adjust the generator to revert to the next 4 digit number. 

0 Replies