Find matching records

[jcc31]

I would like to find records that match one field to another field.

I have three fields. ID1 Name ID2.

I would like to find any record that matches ID1 with ID2.

[Raybaudi]

Hi

make a new calculation field with calc:

Case(

ID1 = ID2 ; 1 ; 0

)

(that can be stripped to the simpler:

ID1 = ID2 )

and make a find by this new field with 1 inside.

[Gar]

Try this modification of previous Script:

Show all records

Go to Record/Request/Page(first)

Loop

If(ID1<>ID2)

Omit Record

Else

Go to Record/Request/Page [Exit after last, Next]

End If

End Loop