2 primary Keys in 1 table

You can't create two primary keys in a table in SQL. Are you sure its 2 primary keys or is it two fields which make up a primary key.

You could create a primary key and a unique key or two unique keys - but by definition there is only one Primary Key.

Also VB 2005 Express edition is a development environment which supports two database - Access and SQL Express. The same applies to both database but to provide more specific details - you need to provide more information about which you are using.

spotty at 2007-8-30 >

The user asked about setting up two primary "keys"

The operative part here is the plural keys - a table cannot have two primary keys.

The designer allows you to select as many fields as you want to create a (singular) primary "Key"

This field can be a single field key or a composite key field but there still can only ever be one primary key.

spotty at 2007-8-30 >

I was simply referring the the title of the thread

"2 primary keys in 1 table"

You cannot have two primary keys in 1 table. You can only have one primary key in a table.

spotty at 2007-8-30 >