(SC 8.1 with MySQL)
I am using Advanced Search and one of the fields, although a small integer, is used as a simple (boolean) for True/False. The standard search criteria offered for an integer are: Greater Than, Less Than and Equal. Ideally I would like a simple check box to select True or False but, in absence of that I would like just two options: such as Yes/No or True/False.
Clearly the system detects the field type. Is there any way of changing this?
I have a for to do for a table where there are ten T/F options which I want to use. A list of check-boxes or as least Yes/No dialogue boxes would require less user training than “use greater than” for True.