Linking 2 databases with the Shopcode, but need also the Year to be linked
Hey guys, good afternoon!
I have two database, one from the financial department, and one from Salesforce. In both of them I have "Year", "Month" and "Shop code".
The link between those bases is with the "[Shop Code]", but, When I select "Year=2013", from the financial database, it doesn't filter correctly the Salesforce Year. I use a different name for the Salesforce Year, because when I use the same, circular references are made, and then it doesn't work also correctly.