Exchange Rates... again
I have searched the forum and haven't found an answer to my challenge.
In my FileMaker database, I have created a table called ExchangeRates that holds a currency code, an exchange rate and an effective date. In my transactional tables, I want to pick up the Exchange Rate from my table based on the date of the transaction - as the transaction might be historic, I need to be able to hold multiple rates.
I've seen the solutions to Auto Enter or Script the Exchange Rate into the transactional fields, but this won't work for my scenario.
Any ideas how I might achieve this? Any help much appreciated.