Identify if one field = another field in a different record

[karlknoblauch]

Hello all,
I have a bit of a problem and was wondering if anyone had a solution for me. I need to be able to flag a record that has the exact same field in another record. Let me give you an example.

The IDKEY in record one = '12345'. In another record, the IDKEY is different, but the IDKEYORIGINAL is '12345'. This second record is referencing the first.

I need a way to indicate in the report that the record with IDKEY '12345' has another record linked to it.

Real life example.
A purchase is done, and an record is written into the database. It has an IDKEY of 12345. A week later, the purchase is cancelled. A nother record is make with IDKEY 22234 but there is a field in that record (IDKEYORIGINAL) that references 12345. I need to flag the original record (12345) that there is another record referencing it.

Any ideas? Thanks alot in advance.

 

[synapsevampire]

If you just need these, add the table a second time and equal join on those fields.

You'll only get rows where they are the same.

To get all rows from the mkain table, select a Left Outer join, then in the details section you can use a formula to determine if they are equal.

-k