I create a table with 2 fields : number and name. Then add two
records, one with 0 and "no", and the other with 1 and "yes". Create
a value list with these fields, but have it showing only the second
field. When you put this into a radio button, it will show Yes and No
for the user, but the field will be storing 0 and 1.
That way you can do boolean operations on the data in the field, but
the user gets the much simpler text.
Cheers,
Nick
On 13/12/2008, at 3:18 AM, Ron wrote:
What do most developers do for a field that should be Yes/No, since
there is no Boolean data type?
FM 8.5
Ron
