I have a table construction like in the picture below in my report
Click image for larger version. 

Name:	ExampleDB.PNG 
Views:	32 
Size:	20.4 KB 
ID:	15445

If i try to open this report i get the error message ambiguous column name on a column of table 4.
What i think DR does is that table 2 and table 3 both join table 4. And then the report joins table 2 and 3 into table 1. So now it has the columns of table 4 twice.
Is there a way to keep both connections because there is no single unique identifier in table 4? But the combination of item 1 and item 2 is the unique value we want to filter on.