Validation

  • Thread starter Thread starter Red2003XLT
  • Start date Start date
R

Red2003XLT

Hello,

Heres my problem

Task table with mulitple assignees. One to many relationship.

How do keep from assigning the person ("the assignee") to the same task?

Thought about using some sort of looping structure however I'm very open to
ideas.
 
Just enforce a Unique key on the two fields (your task ID/name and the
assignee ID/name). That will then ensure that you cannot have:

Task1 Assignee1
Task1 Assignee2
Task1 Assignee2 *** this one would be kicked out


Rob
 
Back
Top