I have a layout that uses three checkboxes in response to a request to rate a text statement. I need a way to allow the user to check only one box.

The two attachments provide a picture of what I am talking about.

The fields to the left of the check boxes are individual fields, each using it's own value list containing one "Custom Value" (i.e. "Positive," "Negative," or "Undecided" that displays in the field when the checkbox to the left is checked.

As you see, I instruct the user to "choose one", but realize that the instruction will likely be insufficient to protect the data base from unintended errors.

I need a script or calculation (or something) that allow users to check only one response. I've tried multiple options but can't get anything to work.

Thanks in advance for any suggestions or insights anyone might have.

Regards.

Why three fields and three value lists - instead of one field, one value list and a radio button format?

Good question for which I have no good answer. Perhaps a bigger screen shot will provide more clarity (or not).

As a new comer to data basing, my understanding of how things get hooked up is not entirely clear. I was thinking that the checkboxes, the rating, and the request for more input i.e.

"what caused you to rate this character this way?" needed to be linked.

In any case, I am open to any and all advice and guidance.

Thanks for your willingness to assist the technically challenged.javascript:void(0)

The screen shots don't tell much about the database itself. You should never let user-interface considerations influence your basic data structure (tables, fields and relationships). Instead, you need to think about what you intend to do with the data once it has been entered (presumably, some kind of statistical analysis) and design your data model towards this goal. Only then comes the question of how to present it to the user - and in most cases there are enough options to satisfy any requirement.

In the attached example, the Rating field actually uses a value list of numbers, but this fact is hidden from the user.

I interpreted what you wanted to be this. You want to prevent multiple choices, Right?

The left one uses a script, with a script parameter for each button. The right one uses a simple set field function.

If you use this, I would make the field inaccessible in browse mode to avoid the stray click that could click more than one.

checkbox.zip

With a single field, you can prevent multiple choices without scripts or buttons (it could be probably be done with multiple fields too, but it would be a lot of work).

checkbox.fp7.zip

Showoff!!!

:

Thanks all for the suggestions and examples.

I think I understand where and why I'm stuck.

Digestion tonight. Rework it in the morning.

Have a great evening.

And thanks again for the help.