Generate Secondary Serial Number
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.