2 Replies Latest reply on Dec 23, 2013 10:01 AM by mercator

    Multiple M:M Relationships in Portal



      Multiple M:M Relationships in Portal


      Good afternoon,

           I am getting nuts with a problem I cannot solve:

      I got 4 tables
      R(idR, ...)
      T(idT, ...)
      C(idC, ..., score NUMBER)
      A(idA, ...)

      The tables have M:M relationships
      RT(idR_R, idT_T)
      TC(idT_T, idC_C)
      CA(idC_C, idA_A)

           I'd like to do the following: On layout for A, I'd like to show a portal, presenting related records from table R. However, I'd like to only show the records from R, if the minimum of the score field is > 0 (the problem, I think, is that a record in R has more than "one way" of being related to A through the C table and I do not know how to do that minimum calculation).

      Thanks a lot for your help and happy holidays,