Convert Currency

Hello all,

I need to do a currency conversion. Here is my set up

table 1 has the site and currency rate (each site is in a different country)

table 2 has site for each part and the cost calculated in USD

I currently have a 1:many relationship going from table 1 to table 2. What is the best way about calculating the correct cost based on the site?

Cheers