finding matching field content

[MrTemp]

working in Filemaker 8.0v2

I'm looking get a found set which consists of all records that have matching content in 2 fields within that record, i.e.

[color:gray]

Include in found set where (content of field_A) = (content of field_

This is for a manual find, no need to script it. This seemed to me to be something Filemaker would have a obvious function for (or symbol to use in a find), but searching through help and doing trial-and-error with various symbols didn't yield any solutions : . Am I just missing the obvious, or is this trickier than it sounds?

Edited August 7, 2007 by Guest

[AudioFreak]

In find mode put the criteria into both fields.

You can search as many fields as you want in find mode. I do this alot to dwindle down the found set I am looking at.

You may also find this interesting.

Michael

Edited August 7, 2007 by Guest

[comment]

Filemaker does not perform calculations during search. You need to add a calculation field (result is Number) =

FieldA = FieldB

Then search for 1 or 0 in this field.

[MrTemp]

Hmm, I suppose I mis-phrased the problem, though the link was interesting .

some background:

I'm working in a flat database in which several thousand records hold redundant information between fields (not between records). I cannot kill off these redundant fields, as they contain unique information as well (good data-entry practices have been non-existent for the majority of this database's life-span). My current goal is to find these cases of redundant information, and edit it out of each record.

To re-phrase the problem:

I'm attempting this find without criteria. I'm not looking for records with two fields containing "Joe" so much as I'm looking for records with two fields containing anything in them, so long as that anything is the same for both fields.

I hope that clarifies my problem, and thank you for your reponse.

-MrTemp

[AudioFreak]

I think Comments suggestion should work for you. Make another calculated field

If ( Field A = Field B ; 1 ; "")

Then search the new field for 1.

That will show you all the records that those 2 fields match.

Michael

[MrTemp]

that should do it. thank you both.

-MrTemp

[Vaughan]

"working in Filemaker 8.0v2"

Arrrgh, that is the worst, buggiest version. Run the 8.0v3 patch on it real quick before you screw up all the indexes.

[AudioFreak]

"working in Filemaker 8.0v2"

Arrrgh, that is the worst, buggiest version. Run the 8.0v3 patch on it real quick before you screw up all the indexes.

What was so buggy about it, out of curiosity?

Michael

[Vaughan]

It screwed up all the indexes.