comparing different fields in separate records

[jreesesrfd]

I need to be able to compare field A in one record to field B in another record. The two fields are key fields so I am trying to identify the parent child relationship of the records within a clients record. Each client can have multiple transactions with each transaction having a parent records with items as a child recored. One record contains the parent key and the the other records have coresponding child keys. I know how to compare them within the same record but I cannot seem to come up with one that ties multiple records together by separate fields. Hopefully this makes enough sense so someone can offer some advice.

I am trying to accomplish this to serve as an audit function because records have not been added into the system correctly so I am trying to avoid manually searching for the incorrect entries.

Thanks.

[jawadhashmi]

Could not get 100% what u want. As I understood you want to compare one row with the other ?

If this is the case: then I would do this using the arrays, I would store the records in one array and then compare them with the others if matches flag them and then show in some other subreport.

But here could be a limit as arrays can be of 1000 records not more then that.