I'm not sure what criteria I'd find this under if it's already been covered, but perhaps someone already knows and can point it out, or a solution would be appreciated.
I've got a table which contains 2 fields, with the second field called 'default' denoting which of the items of the list is to be considered default (it's a yes/no field)
On the datasheet view in forms, I've got both the item and the default field value listed. Is there a way to only allow one record to have the 'yes' value in the list at any one time, and if it needs changing, to uncheck the record currently marked as default and update to the new one?
I hope that's clear enough.
Thanks all in advance
I've got a table which contains 2 fields, with the second field called 'default' denoting which of the items of the list is to be considered default (it's a yes/no field)
On the datasheet view in forms, I've got both the item and the default field value listed. Is there a way to only allow one record to have the 'yes' value in the list at any one time, and if it needs changing, to uncheck the record currently marked as default and update to the new one?
I hope that's clear enough.
Thanks all in advance
