AnsweredAssumed Answered

Set Next Serial Value not working how help menu describes...

Question asked by btschop484 on Feb 7, 2018
Latest reply on Feb 7, 2018 by philmodjunk

So right now I have an ID field that is an auto-entry serial value, increasing increments by 1. The trouble is that when I delete, let's say, ID 7 from the records, it does not reset the field. The new record I make will be ID 8 instead of a new ID 7. So after looking a lot of stuff up, I found the Set Next Serial Value script with some answers. The help menu told me I could set the script to me something like: Set Next Serial Value [Mice::ID; Max (Mouse::ID) +1]. That way the auto-entry serial value would automatically reset to the previously highest ID value +1. I entered everything they said to the line, but still no results. I put in a record, and it is still just continuing by 1 no matter what I delete! Any help??