Help with Non Autonumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need to create a jobref number which contains the first 3 letters of the
client associated with it as well as a number. Each time a new job comes in,
it will need to automatically assign a jobref with the letters and
numbers..... how can this be done? as the only option i have at the moment
is an autonumber..... it will become a little confusing to users should I
use autonumbers for both clients and for jobs.

Any help would be terrific. Thanks.
 
This same question was asked yesterday. sort of.
see the post and solution at
Forms
subject = autonumber...well not quite
posted by Shane
at Jan 10,2005 12:02Pm
Solution by Arvin Meyers
you will have to modify the code a little.
good luck
 
Thanks, I have had a look, but can not make sense of it to use how I need to
use it.
We have lots of different clients, in fact hundreds - and lots of jobs.
Clients already have a autonumber assigned to them. The jobs need a jobref
number linking them to clients along with their own individual number.
Therefore, I need an autonumber of sorts that will display (automatically,
like an autonumber) the first 3letters of a client and a general number (the
number to change sequentially upon each different job).
Ie
TES01 (meaning client tesco, 01job ref) next joblot:
SAI02 (meaning client sainsbury, 02job ref)

any help would be great!.
 
Back
Top