How to create a check box

[smuscat]

I would like to create a checkbox for various categories. Eg. category a, category b, category c, category d etc. Now, the user can choose more than one category at the same time and I will need to issue a report as follows. All records containing category a or all records containing category d. I am very new to Filemaker and need to learn how to create a checkbox.Thank you.

[danjacoby]

Go into layout mode, click on the field and choose Format:Field.

One caveat: when creating the value list, make sure that no value is a part of another value -- for instance, don't have "Director" and "Managing Director", because whenever you search for "Director", anyone listed only as "Managing Director" will also show up.

[cjaeger]

better use a related file with category_id and category_name + a value list with "category_id" + also show "caegory_name". then search for category_id. the checkbox looks like this:

[X] 01 Managing Director

[ ] 02 Director

...

or:

use a global fied + a relation + a go to related record instead of a find ...