allow multiple values for categorical fields
People check multiple boxes in the field, so unless we redesign the datasheets to prevent that, we have to either choose a value or store it. Currently, Forbes is entering these in the notes field.
We could attach the alternate values at notes attached to the field in question. We could use a listBox instead of a comboBox in the interface, substituting itself for the comboBox when the comboBox was double clicked, then reading in the properties from the combo box to configure the listBox.
The only final question to resolve is: what to store in the field? Pick a value at random from the chosen values is the only answer I can think of. Can't store all values as queries wouldn't pull it out and field lengths may not be long enough.