Hi,
I have resolved this. I was not aware that all tables that was related had to be shown in the qry design view. I thought that Access kept track of the relationship paths automatically even though I used only tables in a query that were in the "periphery" in the relationship.