Line item reference
I have a currency module containing Line Items, Time and Version with the line items as currency codes and the values as exchange rates. This has Line items as rows, Time as columns and Version as a page. I have a details module that contains amounts in local currency and a currency indicator. In another module I want to be able to select the exchange rate from the Currency Module based on the currency indicator in the detail module. I have tried various combinations of lookup and select but to no avail. Any pointers gratefully received.