Question about Microsoft Office Standard for PC
Can there be two primary keys for a table?
No, there cannot be two primary keys in one table. You can specify more than one value to make up the primary key. For example, instead of just the last name column - you can have the last name and employee ID fields make up the primary key. If you don't specify a primary key, MS Access will usually ask you if you would like them to create it for you. You may be thinking about foreign keys. A table can have two or more primary keys in them but they would serve as foreign keys. For example - lets say you have table A with primary key "A" and table B with primary key "B". You can create table C and have both primary keys from tables A & B in it, however, they would be foreign keys in table C and not primary keys (they are only primary keys in their respective tables).
Posted on Oct 03, 2007
Tips for a great answer:
Nov 25, 2013 | Computers & Internet
Dec 11, 2012 | Microsoft Office Access 2003 (077-02871)...
Dec 18, 2010 | Microsoft Computers & Internet
Apr 09, 2009 | Microsoft Computers & Internet
Dec 24, 2008 | Microsoft SQL Server 2005 Standard Edition
Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...
Aug 06, 2008 | Sun MySQL
Aug 05, 2008 | Sun MySQL
Aug 04, 2008 | Sun MySQL
Sep 14, 2007 | Macromedia Dreamweaver MX 2004
479 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: