Composite primary key

G

Garry

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
 
V

Van T. Dinh

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.
 
G

Garry

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...
 
Top