Is it possible to make multiple and single select fields reffer to another field with multiple entries?

example:

table has 3 fields named goon type, available goons, chosen goons

in available goons (dependant on goon type), I have a multiple select or a lookup field with several entries, but I have to select only few of them for this specific record in the field chosen goons.

this would fulfill a good part of the void left by the non-existence of data validation.