Please don't do this. An ID should be not only unique, but have NO VALUE. You are imparting value as "BigJ" and that is very wrong. Appending the # 1,2,3 does not make it correct.
......................... Stephen Russell - Senior Visual Studio Developer, DBA Memphis, TN 901.246-0159 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of BigJ Sent: Monday, November 17, 2008 10:51 PM To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting Subject: [DotNetDevelopment] Auto-generating a primary key I see a formula section, but not sure how to go about it. I basically have an primary key called "EntryId" and I want to consist of UserId +unique counter, so if UserId="BigJ", and it's my first entry, then EntryId="BigJ1" and the next entry would be BigJ2 etc....any insight as to how to accomplish this? I know there is a formula field and I am looking into it, but any insight or simple examples are apreciated, as I left my SQL book at home lol...Thanks... No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.4/1790 - Release Date: 11/17/2008 8:48 AM
