Currencies - Best Practice?

[calvindk]

Hi,

I was wondering what the best practice for implementing currency conversion is?

Data Island?

Multiple Linked Currency Tables?

Adding fields into tables?

In my particular case, i have both a budget, committed and actual currency in separate tables, and they could all differ.

None of the tables have more than 500.000 rows

What is the best performing solution and what is the easiest to deal with in the frontend?

Thanks