need help -- assigning records to committees for review

[Steven Cappiello]

I have a table of job candidates, which will need to be assigned to committees for review.

There are 6 committees.

In general, the assignments can be completely arbitrary.

candidate 1--committee 1

candidate 2--committee 2

3 - 3

4 - 4

5 - 5

6 - 6

7 - 1

8 - 2

9 - 3

.

.

. etc.

That would be easy enough I guess.. but, here's the monkey wrench. My boss will need to predesignate some of the candidates in one way or another. He may say, designate candidate 23 to committee 4

or he may say, do NOT give candidate 24 to committee 5

So, I'd like a way to allow for these manual per-candidate rules to be allowed for, WHILE at the same time, in the end, having distributed an equal (or as close as possible to equal) # of candidates to each committee.

so far,

I have the following tables:

CANDIDATE

COMMITTEE

COMMITTEE_ASSIGNMENT

I'm thinking that it is easy enough to manually assign committee assignments for instances where my boss tells me:

designate candidate 23 to committee 4

or do NOT give candidate 24 to committee 5

BUT.. how do I make is so that the arbitrary assignments, which are scripted, should compare all the assignments to the 6 committees so that it keeps them all at an even level ?

I'm lost about how to approach this. Could anyone offer any advice ? thanks ;)