Is there a way I can set it up so I don't have to do that.
I'm trying to model my database and program so that there is a direct correlation between each variable and each field, so if I have to change one or the other that is fine.
Will the checkbox give me a 1 and 0 back when the user edits them? If so can I do a Not(checkbox.value +1) to convert from 1/0 to -1/0 or will I have to put an if statement in there to make it a true or false field?
And would I be better off just making it a number field with a value of 1 or 0?