I have two databases, database_1 contains a field with an assigned value list of check boxes from a field from another database, database_2.

The frustration that I am experiencing is that when I perform a find by clicking on one of check boxes in the field, I am getting the wrong results.

In one case, I perform a find by clicking on one of the checkbox in database_1, the result would be the records with the checkbox actually selected and other records that don't have it selected.

I can't understand what is wrong with my databases...

Attached is a sample of what I am doing. Test 1 contains records that has the field with the check box value list in it taking the value list from the field in Test 2.

Put the copy of edition field on the layout and unformat it to standard field:

Hey there are a lot more data inside it than expected..

Apple Specialist Internal

US Business External

US Education External

A

F

E

D

(when formated as checkboxes it displays only

A

D

E

F

)

Dj

Thanks djgogi. I didn't realize that I had some garbage in the field. It always gets me on how FileMaker represents checkboxes and actually stores them.

Thanks.

A checkbox field is simply a normal text field formatted to display as checkboxes, similarly to pop-up lists or menus. There is no basic difference between formatting text as a checkbox or formatting a date field to display as "MM/DD/YY". The data in the field doesn't change. It's only how you present it that does.