Preventing multiple checkboxes

[emerywang]

Hi. I created a simple form to help keep track of where files are. It's based on a table that has yes/no fields that display checkboxes. So for example, there is a column called "Mary" and another called "John," and in each is a checkbox.



So if Mary has the file, she checks the box under her name. As it stands, if John has the file, he can check his box but has to uncheck Mary's or they will both be checked.

Is there any way to automatically deselect all other checkboxes in that row when one is checked?

TIA,

-Emery

[ConneXionLost]

Hi Emery,

Have a look at using an "Option Group" on your form. It will help to eliminate those extra fields for each of your staff, and put them into one field.

Cheers,

[emerywang]

Thanks, I'll try that.