How do you plan to re-create that number so that you can access the record later? Any "random" value that you would use has to have the ability to be re-created later so that you can access that record.
If you're simply putting records into a table for tracking, you don't necessarily need to have a primary key. You can use an un-keyed table. ...Glenn On Tue, Nov 18, 2008 at 10:22 AM, Jon Liu <[EMAIL PROTECTED]> wrote: > > Right, primary key values are unique. So what I am saying is I want to > auto generate the Id like a counter. Example, when I insert an entry, I'd > like it to generate EntryId=1, then on the next insertion, EntryId=2, then > EntryId=3 so on and so forth... >
