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


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


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.


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