Relationships: A & B are both on the same date, but A & B should not be related

[#1]

Amusement aside, how can I create the right table links so that I can have a table about A which is related to a date, and another table about B related to dates, but to not have A & B directly related to each other? I do want to keep the date field related so that I can have a slider for the time period.

Many thanks,

Isabel

[#2]

Hi Gysbert,

I have followed the solution from the link you suggested and most of it is working great. Do you know how I can correctly pull out the Year from the date?

I have three tables that all link to a date and have sucessfully created a master calander. I would like to have a list of years as well as the month-year dates. I have had a go at modifying the code however I must have it wrong as there is selecting a date does not select the relevent year (and vice versa) as you can see from my screen shot below, when I select December 2011, all years remain selected in my CalanderYear field.

This is the code I have written: 

DateLink:

LOAD
          Participant_Name, Event, F_Attendance_Date as Date
          ,1 as Attendance_Counter
RESIDENT Attendance_Table;

Concatenate

LOAD
          Event, F_Event_Date as Date
          ,1 as Event_Counter
RESIDENT Events_Table;

Concatenate


LOAD
          Participant_Name, Owner_Date as Date
          ,1 as Owner_Counter
RESIDENT Result;



LOAD

          year(Date) as CalanderYear
Resident DateLink

Your help would be much appreciated,

Isabel