data selection

bucket

i'm beginner at Axapta and just started to study this.

i have one problem:
i must get CurrencyCode records from SubsidiaryInfo table in RCashTrans report only when
subsidiary country code is not like company country code.

first of all i must select all SubsidiaryInfo table records,
where this table records are equal to RCashTrans table using SubsidiaryId.

and then if SubsidiaryInfo.CountryRegionId isn't equal to CompanyInfo.CountryRegionId
then return SubsidiaryInfo.CurrencyCode.

is it right?

how it looks in code?