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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OpenReport - the WHERE clause 2
Outlook reminder turned off when tasks are assigned - fixable? 0
Sending an email on workbook save 5
Task Limitations Needing Alternate Route 5
anylizing events 3
Multiple LEFT Joins w/ COUNT... getting really wierd results 1
Web based timesheet application 1
Please Help! Need to add a Variable Range in my Excel Macro withPivot Tables 3

Back
Top