Make sure the datatype is set to int and that the 'Identity' checkbox is checked,
that should work in the same way as accesses autonumber facility ;-)
HtH
-= Edward
:> -----Original Message-----
:> From: Randy Adkins [mailto:[EMAIL PROTECTED]]
:> Sent: Friday, May 12, 2000 4:15 PM
:> To: [EMAIL PROTECTED]
:> Subject: SQL ID
:>
:>
:> Anyone know how to input a unique id within an SQL database?
:> I have a field called Client_ID as uniqueidentifier and do NOT allow NULLS
:>
:> but it will not insert the ID as MS Access does.
:>
:> Thanks in advance.
:>
:>
:> ------------------------------------------------------------------------------
:> 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.
:>
------------------------------------------------------------------------------
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.
