• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

Multiple primary keys via gui

How do you setup multiple primary keys for a table?

I can only get it to set ONE primary key at a time.  If I try to set some other column to be a primary key it marks that column as the primary key and undoes the other one.

for example,

AgentFormOverrideID is the primary key

And I want to also set:

AgentFormOverrideSID as a part of the primary key

mult prim keys
0
Tom Knowlton
Asked:
Tom Knowlton
1 Solution
 
Scott PletcherSenior DBACommented:
Designate the first PK column thru the GUI, as you've done.

Then right-click on the column; select "Indexes/Keys"; click on the "..." after the "Columns"; in the (empty) second line, add the key column you need; click "OK".

Then exit design, doing a "Save" when asked :-) .
0
 
Tom KnowltonWeb developerAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now