A search question

[Totes]

Hi,

I have been playing around with the attached file called boxes someone posted (I wish I could remember so I could give them credit), anyway I am starting to understand the self-join example of the file a little better.

My question is this…is it possible to narrow the search down a little.

Example (disregard the active and inactive fields for the purpose of this question): If on a new record I select “Position 3 (no Buildings are checked)” and then create a new record and select on “Position 3 and Building A” for a total of 2 records in the db.

Now I do a search via the GTRR button for “Position 3” only, no building box checked I get 2 records found the first showing the record containing only the “Position 3” record and also the record showing “Position 3 and Building A”

Is it possible somehow to only show the one record, since I only wanted to find a record with “Position 3” only.

I guess what I am really wanting is for the return to be the record with only my search request, not records with my search request and other fields as well.

Thanks,

James

1175554055-boxes.fp7.zip

Edited February 15, 2008 by Guest

[Fenton]

The problem here is that relational matching is an "or" match. You want an exact match. This would be easy to do if you were searching in a regular text field, you'd just enter the exactly match symbol, "==", in front of the criteria. But you can't do that with a checkbox, unless you script the Find.

So basically a checkbox format is not conducive to non-scripted exact Finds. If it was scripted, there's several ways to produce an exact result, but the easiest is via a straight Find with "==" & single criteria value.

[Totes]

Thanks,

That is easy to understand...I thought I was doing something wrong with the join.