@NigelG I think your second option could work with the selection on the database.
Checkboxes are yes/no so would I need to have a database field for each selector that I wanted in a checkbox?
For example, if I wanted to select from a list of fruits to buy, I would have to set up the database so apple, orange, banana, were each individual fields, instead of having the field simply be “fruits”. Is that correct?