Best Way to Associate these Tables?

[jorkington]

I have a table that lists the year and month as their own fields, which I need to associate with a table that stores a date field. 

What would be the simplest/best way to associate these?

Table 1 :

Financial Year	Year	Month	Data
2016	2015	Aug	#####

Table 2:

Date	Data
1/8/2015	#####

[marcus_sommer · Accepted solution]

I assume those tables are similar like sales- and budget-tables and if it's often the best (and easiest) way not to associate the tables else just to concatenate them - by replacing year and month with an appropriate date, for example with: makedate(Year, Month) as Date.

- Marcus