Grouping Yes/No fields

[sburgess]

I'm in the process of setting up a form, and I have 4 yes/no fields that need to be in it. I want to group the fields so that only one of the yes/no fields will be able to be selected. The fields are: Pass, Fail, N/A, and obsolete.

I tried setting up an option group, but I can't seem to get the information to filter back to the table that is capturing the data.

Any help?

 

[pbaldy]

If the 4 fields are mutually exclusive, it would make more sense to have 1 field with 4 possible values, which would be easily represented by the option group.