checkbox driving me nuts

[tony gasparich]

Ok, I know this is really simple for anyone who uses filemaker all the time, but here is my problem. I have a home finder database that lists community, address, home style, etc. I created a layout with checkboxes to search the database and it works fine if I only make one selection in the checkbox list. If I select more than one checkbox or category, it won't find any of the records. I tried setting it up with a loop, with an else if type of arrangement, etc., but I still can't make it work. If you want the url to the database I can provide it, it is online.

[Lee Smith]

Hi Tony, and Welcome the the Forum.

You are having I believe the same problem as in this post from yesterday Click Here

Also, I'm moving this post to the Find Topic Area, as it meets the sprite of your post better. Check your Private Mail in a Bit, for additional information.

HTH

Lee

[tony gasparich]

I'd like to explain this better using the actual fields. I have a Value List called properties that is a list of 7 names. These names match the names in a field called Communities, but the field called Communities is an edit box with only one name in it per record. I created a field called selectedCommunity and formatted it to be a checkbox value list. Since this is to be on the web and used by anyone, I created a script attached to a button that executes the find. I tried creating a script - Perform Find with a Specify Find Request -properties::selectedCommunity="Country Estates" or "Paramount" and so on.

The basic premise is, take the values clicked off in the checkbox and find the communities with those names. However, it will not find anything if more than one value is selected. I've tried it about 20 different ways but there must be a fundamental flaw somewhere that won't let it work.

[sbg2]

In order to do an OR find you create a New Record/Request for each OR. Further, If you are using 1 field to hold all the Checkbox options each selected Community is stored in a return delimited list like so:

Country Estates

Paramount

Since your Community field holds no record that has the value "Country Estates (Return) Paramount" it will not find any records that match. You need to take the return delimited list and convert to individual values. I have attached an example file, note the use of global fields which you can Get/Set in find mode.

OrFind.zip