Creating Customised Serial Primary Key

[azgaman]

Hello House,



I want to create Customised Serial Primary Keys and dont know how to go about it.

I need Your usual ingenuity.

Thanks.

[RuralGuy]

Why does it need to be the Primary Key? What is wrong with an AutoNumber? Any field can have an unique index on it.

[azgaman]

Didnt really get you. ???

[orange]

Why do you want a customized key?
A primary key is for database system use. So why not use an autonumber?

If you don't have an answer, or are unsure, then I suggest you read this.

Good luck with your project.

[azgaman]

Thank you for your help. I have downloaded the pdf file.

My reasons for customised primary key are:

To be able able to add letters as prefix or short dates

To make the primary key of a table distinct from a similar one.

[orange]

You should research Primary Key and Relational Database Design - you have a misconception of WHAT exactly a Primary Key is.

STart here http://forums.aspfree.com/attachment...2&d=1201055452

[ssanfu]

I have found these sites very useful:
http://www.utteraccess.com/wiki/index.php/Autonumbers
http://www.fmsinc.com/free/newtips/primarykey.asp
http://access.mvps.org/access/general/gen0025.htm

[azgaman]

I have the links and I will go through them.

Thank you.