Cross reference? Beginner question
- A table of accounts
- A table of currencies
- A table of transactions. Each transaction has an amount which is associated with an account and denominated in a currency.
I would like to be able to select an account and see a portal of all the currencies that this account has transactions in and the total amount of the transactions in each currency for this account.