cillion

2xPrimary Keys in one table

Discussion created by cillion on Jan 11, 2016
Latest reply on Jan 21, 2016 by cillion

Hi Folks!

Do someone know how to set up the following:

-One CandidateID field that can be more that one instance in the table

-One ProjectID field that can be more that one instance in the table

-But CandidateID and ProjectID together can never be the same on two different rows

 

Example:

  1. CandidateID = 1 and ProjectID = 1
  2. CandidateID = 1 and ProjectID = 2
  3. CandidateID = 1 and ProjectID = 3
  4. CandidateID = 2 and ProjectID = 1
  5. CandidateID = 3 and ProjectID = 1

 

I deeply thank you for the answers

Outcomes