unique id when form is submitted

["rockhiker" <jimo@xxxxxxxxxxx>]

I have a form that submits data to an access 2007 database. I am using 
formfields:   Is there a way to create a unique id that gets entered into the 
database and display it as an registration/confirmation number on the action 
page? _ THANK YOU

 <cfinsert datasource="design2008" tablename="2008RDCRegistratation" 
           formfields="fullname, Email, County, Title, Phone,  Address1, 
Address2, Payment, CitySTZip, Allergies, Vegetarian,">