Related collection selects eliminating prior selections


#1

I have seen the plugin for related collection selects and I don’t it can
help with this one. Here is the example:

In table “painting” I have among others, 3 fields called colorID1,
colorID2, colorID3…

There is another table called colors with -name- and -id- fields.
I want 3 drop-down menus

The same color cannot be chosen twice.
red, green, orange=====> legal
blue, magenta, blue ===============>not legal

All I want is 3 collection selects that
once something is chosen, eliminates it from the other two lists.

How is this done? And yes i am a noob.