Random generated field but not compulsory

[Chance1234]

I have a table called clients and one of the fields is client ref (NOTE NOT A PRIMARY KEY OR KEY FIELD)

In the business process , when a new client is added it takes a while for their ID to come through.

For purposes of my database i don;t want this field to be blank. What i want to do is to add in some sort of random number reference, which can then be overtyped at a later date

any suggestions for the best way of doign this ?

Chance,

Filmmaker, gentleman and up for parole shortly

http://WWW.5YLAC.S5.COM

,

http://WWW.HOWTOBESPOOKY.CO.UK

 

[PHV]

If your table has already an AutoNumber field you may consider copy this value in the relevant field.
Otherwise you may take a look at the Randomize and Rnd functions.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BoxHead]

You might also consider using the date and time of the record creation.

myField = "Temp:" & now()

If you have multiple people entering new customers you'll have to eliminate the chance of two being entered at precisely the same second:

myField = CurrentUser & ":" & Now()

A function could run opening the form to make sure that there aren't any delays in getting the Customer ID assigned and keyed in - something like...

DateDiff("d",Date(), CDate(Mid([myField],InStr([myField],":")+1))





John

Use what you have,
Learn what you can,
Create what you need.