i'm trying to set up my database so that if one box is checked in a field, then the box in another field CANNOT be checked (no data entry allowed). is this possible?

Can you not use a Radio Button for this?

technically I could, but the two buttons are not logically related and don't belong in the same box...

You could use field validation, but that may be a pain for the user. I would suggest the visibility technique for this. Do a search on this site for visibility.

There are many ways to go here. Field level validation (which I would avoid in this instance because we can); an invisible portal which only shows Checkbox2 if Checkbox1 is empty or attach a script. Script would be easier than invisible portal and more User-friendly than field-level validation.

On Checkbox2, turn off Allow Entry to field (in Field Behavior). Attach script of:

If [ IsEmpty(Checkbox1) ]

Set Field [Checkbox2; If(IsEmpty(Checkbox2); "your checked value" ) ]

Else

Show Custom Dialog [ Button: OK; Message: "Checkbox 1 already selected." ]

End If

Update: Hi there, JT!!!

Do you mean something like the attachment.

HTH

Lee

CheckboxOnOff.fp7.zip