11 Replies Latest reply on Jan 25, 2016 1:04 PM by cillion

    The combination of to foreign keys need to be unique

    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!