I do like this solution! I am aware of the possible "empty" problem but don't care. Thanks for all of the ideas!! Ron Carr
-----Original Message----- From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Nicholas Orr Sent: Saturday, December 13, 2008 2:42 AM To: [email protected] Subject: Re: Yes/No field 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
