I know this has been asked before but the solutions I see are not satisfactory for various reasons.
If I have an enumlist column I can add fixed values to the list. Then when the user sees the field they can select multiple values from this list. I want to store all those separated values in the one enumlist field.
But now I want the values list to come from another reference table and I still want multiple selection capability.
There seems to be no way to do this easily. I can create a list of suggested values from the other table, but they are not โrealโ references. I can use a third joining table, but the user interface is too complcated compared to the fixed value enum and I cannot predict what it should contain.
Is there a simple ie user friendly, way to do this?
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |