----Original Message-----

From: Sonasheth@a... [mailto:Sonasheth@a...]

Sent: 04 May 2000 16:30

To: philp@w...

Subject: (no subject)





hi,

  Thank you!

    I have one question about asp database, I already have some tables 

which

I want to use for my project. Now in order to create relation between them 

I

have to create a primary key right, and key should be unique and not null.

Now I don't have any unique key(colum) in my tables i.e for example caseid, 

ca

seid repeats three time two time in that particular column for one person,

etc., so Microsoft access don't allow me to create a primary key. And 

because

of that I can't do any thing. Please help me I am totally confuse.

                Thank you

                     Sonal

Right, you've got me baffled with this one, Phil. What's he saying? He

_can't_ make a primary key? (I'd stick about three dozen question marks

after that, if I didn't know that Ken Schafer would call me out for it!) I'm

getting to realize that ASP design calls for a lot of broad-range

programming knowledge that some people just don't have, but hey, what

version of Access doesn't let you create an autonumbered primary key? Maybe

we should find him some links to basic database design hints. A database

without primary keys is called a spreadsheet, isn't it?



Daniel Walker



-----Original Message-----

From: Phil Perks [mailto:philp@w...]

Sent: Thursday, May 04, 2000 23:51

To: ASP Databases

Subject: [asp_databases] I have one question about asp database......





----Original Message-----

From: Sonasheth@a... [mailto:Sonasheth@a...]

Sent: 04 May 2000 16:30

To: philp@w...

Subject: (no subject)





hi,

  Thank you!

    I have one question about asp database, I already have some tables 

which

I want to use for my project. Now in order to create relation between them 

I

have to create a primary key right, and key should be unique and not null.

Now I don't have any unique key(colum) in my tables i.e for example caseid, 

caseid repeats three time two time in that particular column for one person,

etc., so Microsoft access don't allow me to create a primary key. And 

because

of that I can't do any thing. Please help me I am totally confuse.

                Thank you

                     Sonal



---

You are currently subscribed to asp_databases 

You can combine columns to make a primary key, it does not need to be a 

single column.  Example, your table has 5 columns fname, lname, mi, ssn, 

address.  I know that ther will be many people with the same first names as 

well as the same last names, I am also sure that if I use fname and lname 

as my primary key I am sure there will be violations, there are many people 

with the same fname, lname combination.  if I assume that ssn number must 

be unique acroos all people and just for saftey I combine that with lname I 

am pretty sure I will not have two people with that exact combination.  So 

in access design my table and select the two columns I need for my key and 

click the small Primary Key Icon on the toolbar.



That's it.



Dave