SELECT MAX(PK+1) into vPK FROM table autonum PK in TABLE USING .vPK
Marc wrote:
HIWe have a few users where the Autonum quits working for some reason.My guess is dirty power or user mistakes.I have a House keeping form where I have a button that they can click to reset the Autonum but is there a way to check for this and fix it in a startup routine?ThanksMarc

