AnsweredAssumed Answered

Generate Secondary Serial Number

Question asked by SamuelWeiller on Oct 7, 2013
Latest reply on Oct 7, 2013 by philmodjunk


Generate Secondary Serial Number


     Hi all!

     I am working on a database managing people and projects. Each person gets a unique ID no. when they are first entered into the DB, but for certain projects, we need to generate a second unique and sequential ID for these people if they are assigned there. Ideally, I would love to have a button to press in the contacts DB that would generate this number. So far i have tried using Max( SecondaryID ) + 1, but it starts at one on every record. At this point there will not be more than one person at a time accessing the DB, but I would like to have that possibility available in the future.