set the default value to be a three digit. lets say "100"
So the 1st record will have the value id 100
Increment it your form
<cfset Value_id=#ValueidFromDatabase# + 1>
Insrt the Value_id in your next record.
There might be a way to set default values too
Sql sever allows to set the default value and increment it by
whatever value you want. Access should allow this feature too!
--- Original Message ---
Denny dd <[EMAIL PROTECTED]> Wrote on
1 May 00 07:40:29 MDT
------------------
Hi!
I have an insert form and I want that when ever this form is
loaded the value
of my "Code" field should be incremented.I know that in access
database we
have the option of datatype as autonumber but I want my code
to be of 3
digits.
Thanks in advance
Denny
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
-----
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
