Enchanced multiple/single select (may be related to data validation)

[Klaus_Becker]

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.

[Elias_Gomez_Sai]

Maybe you could use a View with hidden Fields and Filters, just for saving space etc.