AnsweredAssumed Answered

serial number range for multiple users

Question asked by on Feb 23, 2012
Latest reply on Mar 3, 2012 by

I've created a database for 5 users.

While this has been in use for years, we're adding a different calculation for the serial number so everyone has their own number range.

The serial is not the key field.


I've defined a base number range per user log in account







When a new record is created, I'd like the serial number to reflect the person's log in account (for example-ab) and their last used number- maxSerial + 1 .

I'm thinking the best way to track this is to create a table to calculate where the users are at and pull the correct field calc in to other table via set field?

It seems simple but I can't think of the best way to set this up.

Please help!

Thanks in advance,