Composite primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have seen references in several Access books to a "composite primary key".
However, none of them say anything else. Is it possible to do this? and if
so how and are there any problems. I hate autonumber, and it appears that a
composite key would allow me to avoid it.

Thanks Garry Gross
 
It is a PK that consists of 2 or more Fields in the Table.

In the DesignView of the Table, click the rectangle on the left of the Field
name to select the first Field. Hold the Control Key down and click other
rectangles to select additional Fields. After select all Fields you want in
the PK, click the PK icon in the Table Design ToolBar.

You can also use the Indexes icon or the Menu View / Indexes ... to create
PK for the Table.
 
Van
THANKS!!!
Garry

Van T. Dinh said:
It is a PK that consists of 2 or more Fields in the Table.

In the DesignView of the Table, click the rectangle on the left of the Field
name to select the first Field. Hold the Control Key down and click other
rectangles to select additional Fields. After select all Fields you want in
the PK, click the PK icon in the Table Design ToolBar.

You can also use the Indexes icon or the Menu View / Indexes ... to create
PK for the Table.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

composite key unmatched query 1
Creating composite primary keys in SQL 2
How do you create a composite key that can be referenced? 3
Data Primary key vs. Artificial (Autonumber) primary key 78
Creating a composite key 4
How can I avoid duplicate names? 4
creating a composite key 8
unique composite key 6

Back
Top