multi-field primary key

From: "sql guy123" <stoppal@xxxxxxxxxxx>
Date: 28 Nov 2005 09:37:07 -0800

I have a table (table1) that has a bunch of fields....

[field1]
[field2]
[field3]
[field4]
[field5]

None of these fields are unique, but if I combine them, then they are
unique.

I know there is a way to make multi-field primary keys, but when I try
I get an that field1 is not unique, which I already know,

How can I make a multi-field primary key?

thanks

.

Follow-Ups:
- Re: multi-field primary key
  - From: David Portas

Prev by Date: Bulk Import with header in text file
Next by Date: Re: CASE problem
Previous by thread: Bulk Import with header in text file
Next by thread: Re: multi-field primary key
Index(es):
- Date
- Thread

Relevant Pages

Re: Unexpected Behavior in try/catch
... $sql = qq { ... SET field1 = ?, ... AND field5 =? ...
(perl.beginners)
Re: Comparing Two Identical Tables - Loop Through fields in a Recordset
... Field3 = CC ... Field5 = EE ... Field7 = GG ...
(comp.databases.ms-access)
Comparing Two Identical Tables - Loop Through fields in a Recordset
... Field3 = CC ... Field5 = EE ... Field7 = GG ...
(comp.databases.ms-access)
Re: Finding records with equal values in 3 fields
... > Amir wrote: ... >>Lets say I have a table named tblMyTable, which has 4 fields: Field1, ... >>Field4, then selecting only the groups which has a total of more than 1 ... > FROM tblMyTable INNER JOIN qryGetCounts AS C ...
(microsoft.public.access.queries)
Re: IF then
... Both situations rely on the value of Field1, ... Field3 = False ... Field4 = False ... Candia Computer Consulting. ...
(microsoft.public.access.formscoding)