I'd like to solve the following problem:
There is a table "element" and a table "problem" with a 1:n relationship (element can have multiple problems). In a problem report I'd like to show all problems grouped by element. So far all works well but elements with no problem do not show up in report (obvious because there is no problem reported). So I'm creating for each element a "no problem" entry in the problem table, now all elects show up in a report.
I think there must be a much more efficient way to solve this, because I'm creating thousands of "no problem" entries? Any suggestions?