I'm trying to create a form whereby I can add multiple values to a table. I want to select the values using a list of check boxes, but there are a lot of values- is there anyway to automatically generate check boxes based on all the possible values in a column? I see how it is possible to create a multi-value from a checkboxlist, but this is not what I want.
The column is 'Skills', and examples of values I want to add- several per individual- would be things like 'sewing', 'carpentry', 'arts and crafts' etc.
New skills will be added in the future, so i want the list on the forms to update to include the new skill with a new textbox. To me it sounds like it should be an easy enough thing, but there is no option I can see for it.