Need to bring the Currency filed

[Mahamood0218]

Hi PBI Experts,

I have two tables "ap_invoice" and ''Tcurr'' ,i want bring Kcurst field from "TCurr" table where fcurr = USD  (USD to INR ,EUR,JPY)

Output like:

Thanks,

Mahamood

[olgad · Accepted solution]

Hi, 
create a concatenate of invoice date and currency in the first table and payment date and currency in the second table. then create a relationship between two tables on the primary key
Primary Key= Invoice date &","&inv_currency_code
Primary Key= PaymentDAte &","&fkur