Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TWO Primary keys!???? 1

Status
Not open for further replies.

reta

Technical User
Dec 23, 2004
51
AU
Hi
Is there a way of creating TWO primary keys in a table in access 2000.
Thanks
Reta
 
NO, but you may create many UNIQUE index.

But perhaps you want a PK on 2 fields ?
To do this, in the table design view select the 2 fields and click the PK toolbar button.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top