web query with complex AND/OR structure

[pedi]

Hi,

I got the following problem:

A text-field (t) and 4 boolean-field (b1-4)

Now I'd like to do a query similar to this: (t==demo) AND ( b1==true OR b2==flase OR b3==true OR b4==true)

Do you have some ideas how to do this ?

[Vaughan]

To do this in FMP, it would require four find requests. Relatively easy to do directly, not so easy through the web.

Instead, I'd have the find performed by a scirpt. If the find is one that can be "canned" then it's even easier, just get the script working and call the script through the web form.

If the script cannot easily be canned, then the users will need to eneter the data into fields, then the form action needs to grab these fields then perform the script. Just a little bit harder.