I would like to list all options in the select by category:
<optgroup label="cat1"><option 1...>
<optgroup label="cat2"><option 4...>
I have all options in a db table where one column holds the value and another column holds the category:
option - category
option 1 - cat1
option 2 - cat1
option 3 - cat1
option 4 - cat2
option 5 - cat2
option 6 - cat2
I would like to create a repeat region that holds the category and a nested repeat region that holds the options.
It seems the simplest solution, actually, is to create multiple recordset (one per category) and display them in the <optgroup> tags created manually.