the solution
well I hope this is still useful for the one who opened the thread.
In the report design view open the query builder from the record source.
on the join properties window (appears when you double click on the relationship line). Select option number 2. This will show records from...
