boolean feeld

[concrete]

what is the best way to have boolean fields.

for example:

gender: man/woman

or

yes/no fields

[djgogi]

I'm always using 0/1 logic so that I can say

Case(flag, value for case 1,value for case 0)

BTW this requires additional fields for display purpose.

Dj

[Chuck]

I would only use a "boolean" field when the field is actually holding an on/off or true/false possibility. For gender I would use a text field tied to a value list and validated by the value list.

Keep in mind that for FileMaker, a boolean field is simply a number field where a value of 0 is interpreted as "false" and any other value is interpreted as "true". I usually name such field beginning with the word "Is" or "Has", as in "IsPrimaryContact" or "HasOutstandingBallance". This makes calculations based on the field easier to read, as in "If ( HasOustandingBalance, ... )".

Chuck