Crosstab with indirectly linked criteria

[Ssstacey]

Hi,
Ive been through several of these threads, but I still cant figure this out.
I have a crosstab query in which I would like to put a criteria. I understood that I have to use parameters for this. But, the restriction I would like to impose on my crosstab query is not directly,but indirectly linked to the variables in the crosstab. I tried to add the other table in order to insert the directly linked variable, but this confuses the whole crosstab (I get duplicate rows).
Is there a way i can fix this?
Thank you
Stacey

 

[Ssstacey]

I added another table and connected ( put a join line) to the already existing table from which I take the information for the crosstab. Should I change this?
Stacey