RE: [MS_AccessPros] Primary Key

 

There can only be one primary key per table. That primary key may be a complex key combining two or more fields. The combination that makes the primary key cannot be duplicated within the table. The individual fields that participate in the primary key may be duplicated within the table.

 

 

Darrell

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, January 25, 2016 12:04 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Primary Key

 

 

Is it possible when  defining multiple primary keys for a table, to specify that only the combined primary keys can not have duplicates , but the individual key can have duplicate entries?

Sarah

The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.

Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.

__._,_.___

---

Posted by: "Embrey, Darrell" <DEmbrey@bcbsm.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (12)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___