Showing incorrect dates

[#1]

Hi,

I've attached a sample of my .qvw.

It should return the Start and EndDate from what is saved to the excel file, but instead it's returning(shown in the tablebox), the same Dates input (variables) from the CALENDAR object...for all the names.

I think I may be joining the tables incorrectly, but not sure how to correct this?

Any ideas?

Many thanks!

[#2]

In your Periods table you have only 1 line with start day 2/4/12 and end date 5/4/12

You also have a 1-n relation between periodid and ID, so it's seems right what your charts are showing.