Only one record allowed to have a check box checked

Hey Jerry, this can be done in the database itself, but I don't know if you can do it through CMSBuilder.

I'll refer this to Dave, he might have a solution.

I should specify - I think this can't be done with a checkbox field at all, so you may want to look into using another field type.

Hi Guys, 

When you set this option in the Field Editor: 

Unique       [X] user may not enter the same value as another record (not case-sensitive)

It checks that no other records have the same value, but it ignores "blank" 0-character values when checking.  So it doesn't work for checkboxes because checkboxes store their state as either 0 or 1 in the database meaning it would allow one record with a checked box and one with an unchecked box.

But what you could do instead of a checkbox would be to use a list field and set the list values as follows:

|No
1|Yes

And then check the "Unique" checkbox.  That would store blank "" for the No value and 1 for the Yes value (and you could use whatever you wanted instead of Yes/No).  Furthermore, it would only allow you to have one record with 1/Yes set and unlimited records with blank/No set.  

It's not a checkbox, but pretty close, and you can rely on consistent user input since they can only select those two options.

Hope that helps!

WOW!!!!

What a great idea.

Thanks,

Jerry Kornbluth