Finding all records that match selections in checkbox field

[Rebel Minion]

Hello All,

I have a checkbox field(global) with about 12 options in it.

I want a user to be able to have some number of of the boxes checked and then be able to print all the records that are in the categories selected.

I have setup a find to do this:

The find is setup like this:

Enter find mode

Set Category = gCategory (the field where user has made their selection)

Perform Find

What is happening is that filemaker is trying to find records whose category is ALL the categories selected - of which there are none since each record only belongs to one category.

In other words, the search is being treated as find CAT1 and CAT2 and CAT3 instead of find CAT1 OR CAT2 OR CAT3.

Can someone clue me in on how to do this search correctly?

[aaa]

Hi, Rebel!

I think taht,If you want that your find work as CAT1 OR CAT2 OR CAT3, you can in find mode create one "Or" button which adds new request, and check your "Or" request in the next request.It will be better, if your find mode look as list of requests, where you can add or remove requsts.

Edited December 26, 2005 by Guest

[Raybaudi]

Hi

give a try to this.

FindChecked.zip

[Rebel Minion]

Thanks for the suggestion.

I was actually using a similar relationship to find material in a portal dynamically. I have no idea why it did not occur to me to simply go to a printing layout in the linked database!

Thanks Again!

R