AnsweredAssumed Answered

serial number range for multiple users

Question asked by nancyhorne@centurytel.net on Feb 23, 2012
Latest reply on Mar 3, 2012 by nancyhorne@centurytel.net

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

ab_10000

cd_20000

ef_30000

gh_40000

ij_50000

 

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,

Nancy

Outcomes