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.
Thanks in advance,