Database design issue

Hi:

I have a database design issue. Let me first state the problem.

A user stores his transaction details like

order id, user id, order desc, amount spend, transaction currency

into a table. Each user has an own-currency associated with him.
But he is free to do transactions in any currency.


A report has to be generated for this table. Catch is that, who ever
is generating the report wants to see the amount in his own currency
(otherwise he cant total the amount).
So at the time of report generation, for each row, it has to calculate
the FX rates for that amount. This creates huge performance problem.


Introducing 2 or 3 columns more and storing amounts in diffrent
currencies was the first idea came to my mind. But this doesnt scale
well.

Can anyone suggest an idea to overcome this.

Thanks in advance.

.

Relevant Pages

  • RE: Assigning Duplicate Values
    ... and numbers transaction amounts, and the colors are account numbers, I simply ... As an alternative I started looking at doing a count by dollar amount, ... Posting Year Posting Month Month Day Year GL Ref# Amount GL Account ...
    (microsoft.public.access.queries)
  • Re: Visa Debit Payment
    ... credit cards isn't always the amount entered on the card terminal. ... Sometimes the debit aquires a '0', ... Sainsburys are aware that an equal number of transaction ... I do my card reconciliations two working days after the transaction. ...
    (uk.legal)
  • Re: Lord Help Me Project
    ... The fields in the main form only serve as account identification information, ... different amount types. ... subform are changed, but I'll post those issues on the forms community. ... If you think of your checkbook, it's the "transaction ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Lord Help Me Project
    ... different amount types. ... subform are changed, but I'll post those issues on the forms community. ... If you think of your checkbook, it's the "transaction ... than one account. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Lord Help Me Project
    ... in when I add a new record to the subform. ... If you think of your checkbook, it's the "transaction ... where I've used foreign keys to tie the transaction to a certain account ... Requirement - $ amount the office says is required perform a certain ...
    (microsoft.public.access.tablesdbdesign)