1 2 Previous Next 23 Replies Latest reply on Jan 21, 2016 1:37 AM by cillion

    2xPrimary Keys in one table

    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

        1 2 Previous Next