Getting a row level operation by using two different tables

 sahubibhuti45 

1. create a new column in both table as follow : 

curreny_col_name & "|" & date 

nB:  make sure that the date is written in the same format in both tables. 

2.now you can link the 2 tables, on this column created . (  it should be a 1 to many relationship going from currency history table (1)  to loan table ( many ) 

3. 

from here, things should be easy. 

you can create a new column in the loan table as  : related( curreny_history_table_name[ conversion amount col name] ) 

now you have the conversion amount in your loan table. 

hope this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠