AnsweredAssumed Answered

The combination of to foreign keys need to be unique

Question asked by cillion on Jan 25, 2016
Latest reply on Jan 25, 2016 by cillion

Hi

Do someone know how to set up the following:

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

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

-But CandidateID_FK and ProjectID_FK together can never be the same on two different rows.

 

That mean that only one person can be assigned to one project one time.

 

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

 

Now my configuration looks like this:

2016-01-22_14-40-05.jpg

2016-01-22_13-43-45.jpg

 

I deeply thank you for the answers!

Outcomes