Posted by sql guy123 on 11/28/05 19:37

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

[Back to original message]