How to make my exchange date link to my master calendar ?
I have a data model which is i start with exchange date table. after i add my data model with sales table plus master calendar and now i notice that my exchange rate table date need to link to master calendar.
May i know how to make change of my script into to link my exchange date table to master calendar.
This morning i think i found the issue , i notice that my Rate Table also link to Temp table which store all the date. So i need to create a key to link to sales table. now i link from Rate table , it does not link the date over.
Any idea how to make the temp table create a link key ?