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, 200817 yr by Guest

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.

Thanks,

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