Hi, I have created a db in sql server 2005 and connected it to info path to use as the front end.

My problem is I would like a Unique ID for the Customer so every time a form gets completed by the end user in info path a unique ID is generated. So im guessing the Unique ID in would be generated by the sql server and not front end.

What would the datatype be for a Customer_ID would it be a (uniqueidentifer) and how would I make it generate a Unique ID on the front end, as this is how i currently have set it up but no ID is automatically generated in the front end?

For example, in the Customer_tbl the primary key is the customer_ID would this be stored as a uniqueidentifier so am I missing default values?