How to create a drop-down list and be able to select more than one entry.

HansVogelaar That's an interesting solution. And I can imagine a few situations where it might be helpful. Perhaps the situation presented by Jesus_Hernandez is one such.

HOWEVER, and it's a big however: there's a potential downside to allowing multiple entries in a single cell. Depending on what use will be made of the entries down stream, allowing multiple entries can create havoc with regard to data integrity.

For example, in the original posting in this thread, Jesus_Hernandez shows two of the four possible responses as "Enhancement" and "Bug" -- although it's remotely possible that an enhancement could be a bug, there's also an inherent logical inconsistency there. So if that field is being used as anything other than an answer to idle curiosity--i.e., if the entry has any real significance in downstream processes--it would be better from a data integrity point of view not to allow them to be combined. Same for "New" and "Enhanced": which is it? It can't be both/and, not if the labels have any true meaning; has to be either/or.

The alternative? Have a date field on each record, or even a date and time, and keep history of entries, so that we know that what was once reported as an enhancement turned out to be a bug or to have a bug, etc. Keeping the history is important, but don't muddy it by combining two different states of affairs into a single row.