Link tables

[#1]

Is it possible to link the two tables and give the right Rate by the good record in Table1

TABLE 1
Orderline	OrderDate	EUR value
1	15-1-2010	10,00
2	15-2-2010	10,00
3	15-3-2010	10,00
4	15-4-2010	10,00
5	15-5-2010	10,00
6	15-6-2010	10,00
7	15-7-2010	10,00

TABLE 2
Date from	Date until	USD Rate
1-1-2010	31-3-2010	1,25
1-4-2010	30-6-2010	1,29
1-7-2010	30-9-2010	1,34

[Miguel_Angel_Baeyens]

Hello Alfred,

Check the sample code in this post.

Hope that helps!

[#3]

Thanks Miguel!

It is the right syntax