I have a custom object
Object_X, which has a checkBox field
Activate__c. My requirement is that only one
Object_X type record can have the
Activate__c checked at any given time. So if
Object_X already has a record with
Activate__c checked, another record with
Activate__c checked should not be allowed to be created.
I already have a trigger for this but I'm wondering if there is a way this can be easily achieved by a validation rule.