AnsweredAssumed Answered

Special Relation/Query

Question asked by on Jan 29, 2015
Latest reply on Jan 29, 2015 by erolst

Hi Folks,


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?