Checkbox Fields Vs Multi-Select Fields for Tracking
Hi, I have a table with physicians and the advanced privileges they may have. There are 9 advanced privileges (there could be a few more down the line), and each physician may have a unique combination of these privileges.
I’m trying to decide whether to store each privilege in its own checkbox field or use a multi-select field where you can choose the privileges that apply.
I like the multi-select approach because it’s more compact, but my concern is that I need to be able to select a single privilege from the list of 9 and see all the physicians who have that privilege. I'm not sure how to do that with a multi-select field.
Can anyone advise on the best way to set this up?
Thanks!
I think a multi select field is the way to go. It can be used as a Dynamic Filter on reports and can also be used as a regular filer on a report.