Reference Number Generation

[mbgaldl2]

Save Me From My Reference Number Generation Hell

Hi Guys

Dont quite know if this is the right place to post this but here goes any way

Im creating a database where customers can submit a question, it centres around a form where a user enters various information such as initials, telephone number, and various selections from from down boxes.

I have placed a button at the bottom that saves the record, what i want is when that button is pressed for a box to pop up giving the user a unique reference number which is made up of the information they have entered, such as
FIRSTINITIAL-LASTINITIAL-DATE-INCREMENTALNUMBER
I want this number then to be stored along with the record so it can be searched for by this number.

I have done searches for similar questions but cant find one that matches what i want to do

Thanks in advance

 

[jwhite]

[ No one has replied yet???? ]

Rather than go to all that code, why not create a field CustNameShort set as 'No Duplicates', and allow the customer to type what they choose - affording them the ability to remember the ID better?

 

[GaryPanic]

pretty simple this one
have a field in your table and then after update of the last field have this =
the field on your table/form the incremental number should be the autoid number

however this is not the best way of doing this

the easiest way would be unique number only or postcode(zip code) + unique number