I switched the Boolean fields in my database to number fields based on Allen Browne's concerns about the problem with Boolean fields causing errors in queries. I would still like to be able to use checkboxes, so I am sticking with 0 and -1 as my values. However, there are times in list views when I don't want a checkbox because it is too easy to uncheck a box when you are scrolling through. In that instance, I would like to select from a combobox with the values Yes and No in the list. The table would look like this:
I know you can create a join on any field, but I have never thought about using negative numbers in a join. My concern is causing a condition where I could corrupt the data, otherwise this seems doable to me. Would this work, or does someone have a better solution?