Boolean field formatting -> single check or radio button?

[rich williams]

Hi All,

I am using ESS and hooked up to ms sql db. I have a column in the db of type BIT. with possible values of zero or one. This is the typical way of storing boolean/true false values.. What is the best way to handle this in FM?

I notice with radio buttons the labels and values are not seperate.. And also i can't make a single checkbox.. checked meaning true and unchecked meaning false.

Am i missing something? how can i handle this? thanks!

[mr_vodka]

For Boolean checkboxes, I usually just use a value list with value 1. Then ties that value list to the field with a checkbox. You can resize the checkbox to not show the text.

FileMaker has very loose data types. So if this were in a FileMaker table, then you could just use a number field.