How to use certain field values of a parent record while working with a sub record in a set analysis

[vvira1316]

Hi,

I've situation where I've to do calculation in set analysis where I'm working on record with CPDID 330398 from information included below. It is a sub record that is identified using "Rec Type" field. It is to be included in selection based on some criteria say "Created Date" or "Aging - Last Updated" field values of record "CPDID 60218", "Rec Type Main - Generic"

Is it possible to do check on a record or work with a record (sub) and use another record (parent/main) for certain condition is met in main/parent record

Let me know if any more information/clarification is required.

Thanks,

Vijay

[vvira1316]

I achieved it by created another table with related information from the main table that is linked using ID column.