Hi, Suppose I have "Test Lsit" with two columns "Title" and "Auto Value". while inserting new value , Title should be entered by user. I want "Auto value" column should have "title" column's value with unique ID number. Is it possible through SharePoint Designer 2007? I know that we can have unique ID but about concatenation of column value no Idea. Regards, Jayashri

Create calculated column. Refer below links http://office.microsoft.com/en-us/windows-sharepoint-services-help/calculate-data-in-lists-or-libraries-HA010105480.aspx http://blog.pathtosharepoint.com/2008/08/07/calculated-columns/Thanks & Regards, Neerubee

Sure, create workflow, when create or update record, set field Autovalue = ID

Hi, Thank you for help. It is working fine. I have used concatenate function and created a new column, which display concatenated value of "title" and "Auto Value" column. Thanks Regards, Jayashsri.

Hi, Thank you for help. It is working fine. I have used concatenate function and created a new column, which display concatenated value of "title" and "Auto Value" column. Thanks Regards, Jayashsri.

Thanks. regards, Jayashri

Thanks. regards, Jayashri