auto number for job # per ClientID

[Guest]

I would like to have a given field called job# be an autonumber - which i
know I set in the table field properties. But Each time on the form that we
use to input this - you select the clientid first(from a dropdown) then input
the job# - I would like the job# to be autonumbered(a word) for each Client
id-

Thanks for your help in advance,
Barb

 

[ruralguy via AccessMonster.com]

Hi Barb,
If you or anyone cares about the value of the field then do not use an
AutoNumber. Create your own numbering and incrementing system.

 

[Guest]

Not sure what you mean by if we CARE about the number - does that mean new
set of Autonumber with new job# - How would I do this - Set up a table????
with numbers tied to jobs - not getting how to do this???

Thanks,
Barb

 

[ruralguy via AccessMonster.com]

AutoNumbers are simply for unique numbers for a record usually as a Primary
Key. It is generally accepted that these numbers are "not for human
consumption", meaning the user never sees them. If you need a sequence of
numbers then use DMax() in the BeforeUpdate event of a form to get the last
number and add one to it. If you want the user to see the number then *also*
use the DMax() in the BeforeInsert event of the form but do it again in the
BeforeUpdate event if it is a multi-user application or there could easily be
duplicates. There is still a possibility of duplicates using the
BeforeUpdate event but the window is *very* tiny.

Not sure what you mean by if we CARE about the number - does that mean new
set of Autonumber with new job# - How would I do this - Set up a table????
with numbers tied to jobs - not getting how to do this???

Thanks,
Barb

Hi Barb,
If you or anyone cares about the value of the field then do not use an

[quoted text clipped - 8 lines]