Find records with one field = another field

[obesefelinex]

Is there a way to find records where one field in the records equals another field in the record? The matching values will likely be different from one record to another.

[Raybaudi]

Yes, there are many ways...

for example you can create a new calculation field with this calc:

field1 = field2

and search for records that have 1 inside that calc field.

[obesefelinex]

For a fixed pair of fields, you're right of course. But is there a general way to do this with any pair of fields using Ctrl/F?

[comment]

I don't think so, but you can make the calculation more flexible, e.g.

GetField ( gFieldName1 ) = GetField ( gFieldName2 )

Of course, this needs to be unstored, so the find may take a bit longer.