Please find my Table structure as follows. i have created a master calendar within the range of min and max using four date fields in below four tables. what my concern is i want to link the date in master calendar to all four tables BudgetedSalesDate, ProjectionSalesDate, ConfirmedSalesDate and ActualSalesDate to filter the data as per the selection of Date, Year, Month or Week in Master calendar.
Can any one please suggest me a way to solve this.?