Searching a field with Value List

[macaroni]

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.

[djgogi]

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

[macaroni]

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.

[-Queue-]

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.